I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the internet connection goes down. It occurs to me that a local SQL Server 2005 instance should def...more >>

I am new to SQL Server replication. For some reason, in Microsoft SQL Server Management Studio (for SQL Server 2005), if I run an "alter function" statement, "alter procedure" statement, or "alter view" statement, for an object that is an article in a merge publication, the command never fi...more >>

Hi, I'm setting up a three-tier replication. The top tier is a corporate server running SQL Server 2005 STD. That is setup as a publisher. The second tier is many district servers running SQL Server 2005 STD. Those are setup as subscriber/publisher. Within each district are many offices runni...more >>

Hi, We have Merge Continuous replication. Every couple of days the Merge agent stops with an error: The process could not enumerate changes at the 'Publisher'. Source: Merge Replication Provider (Agent); Error number: -2147200999 We are running on SQL2000 Standard, SP4. The OS is Windows 2000 S...more >>

Friends, have any one set up above said techs between datacenters (2 or 4, more). please evaluate pros and cons. Thanks,...more >>

Hi, Nearly 100 tables are in merge replication and I need to remove 5 tables from replication. Is it possible? If so what are the steps I have to follow? Please advise. Thanks, Soura...more >>

Hi, We are looking at implementing Transactional replication for our production. The initial set up did not work for us becuase the generation of snapshot was having serious slowing down of production. We cannot take our site down just for generating multiple 40G database's snapshots. My ...more >>

When I look at my publisher and the publications in EM, they say they are transaction replication. HOWEVER, when I run sp_helppullsubscription on both of the subscriber DBs, they return a publication_type of 1 (well except for one of them which returns a 0 and is the one causing me high latency ...more >>

I am developing a transactional replication plan. I have one table that most of the time I do not want to replicate deletions. There is an exception to this rule. If the status_id of another table is false, then the deletion should be replicated. I have been having difficulty trying to put ...more >>

Hi everyone, I have a problem with one of my publishers. When I click on the "Articles" tab under the "Publication Properties", I see all my articles but everything is greyed out. I can't uncheck any of the articles and I cannot add any. I need to add one more article to the publication! ...more >>

I am trying the snapshot replication. The publication and snapshot agency in a SQL Server 2000 machine and subscription in a SQL server 2005 machine. Is it possible? I could not made it work. I found I could only Push 2005 Publication to 2000 subscription. (Pull not working) Thanks ...more >>

It seems every time a snapshot is made the next scheduled run is disabled and listed as "unknown" on the status tab of the agent properties. Once I go back into the schedule properties and re-enable, it runs that night but then goes back to unknown the next day. Any ideas? I've seen similar post...more >>

I have an application that has been using a right outer join that worked as I expected until I added merge replication. On the replicated database the result is the same as an inner join. I could be doing something odd but it's a pretty plain use and it still works on instances of the database...more >>

Recently I have experienced problems with subscriptions getting out of sync. Some of the published tables are very large and are connected to the subscriber via t1 connection. To avoid re-initializing the entire publication I ran sp_dropsubscription followed by sp_droparticle, both specifying ...more >>

SQL 2000 trans replication. I have a fat table (100+ columns ) being replicated minus a couple columns. . How do I query the replication sys tables to find all columns being replicated? Goal is to find which columns are NOT replicated. Thanks in advance, Chris...more >>

After installing SP4 on distrib and publisher (subscr SP3) on one article in merge publ a problem of bitmap occurs when updating one column on subscriber : i updated col44 of the table on subscriber, i saw on trace that the repli applied update on col43 any clue? TIA bruno ...more >>

If I have applied a database dump to the subscriber for a no-sync database that is using snapshot replication, do I need to keep applying new snapshots? The distribution agents seem to be "delivering transactions" but not as many as when I used transactional repl on the same database (this was n...more >>

How can I get a list of all the triggers associated with a particular table in a database. And in addition, how can I get a list of all triggers for the entire database (meaning all triggers associated with all tables)? Thanks!! -- Regards, Troy...more >>

Hi, I create a column in a table that is in a merge publication with this code USE JMI GO sp_repladdcolumn @source_object='ztest',@column='dateDepart',@typetext=' datetime NULL DEFAULT getDate()' ,@publication_to_add='JMI_articles' GO I realise that a made a mistake and i want to dro...more >>

Hi Guys, I have recently removed replication from the SQL server (2k) and everything seemed to be working at first. Initially, the database still contained all the conflict tables etc... but I got rid of all those. However, now, when attempting to insert into some tables in the database...more >>

Hi, Just completed the transactional replication and when tried to test the changes made in the publisher data it (Distribution Agent) failed with the following error: ----------------------------------------------------------------- Could not find stored procedure 'sp_MSupd_ACCOUNT'. (Sou...more >>

I need to delete a transactional publication (no subscribers) and the associated database. I have tried to use sp_droppublication and sp_replicationdboption without success and I believe that this is due to some of the conflict tables being deleted from the published database. Is there any...more >>

I have more than 500 databases on my sql server 2000 enterprise edition. I have already suffered the deadlock problem mentioned in http://support.microsoft.com/kb/246330 So, I tried to upgrade to sql server 2005 but still unable to implement transactional replication for large number of databa...more >>