Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Replication, SQL Server 6.5 Rss

   Items 1 to 4 of 4   
 

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.   Read more...
By Andy Warren 2004/10/15 (first published: 2001/05/04) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,466 reads

Non_Continuous Replication

Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.   Read more...
By Andy Warren 2001/05/15 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,693 reads

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.   Read more...
By Andy Warren 2004/10/15 (first published: 2001/05/04) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,466 reads

Altering Replicated Tables

Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!   Read more...
By Andy Warren 2001/05/02 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 7,210 reads
   Items 1 to 4 of 4