SQL Server Performance Forum – Threads Archive

HELp !

i have sql server 2000 transactional replication installed on a production system. 1 publisher / distributor (same box)
4 subscribers ( 4 separate db servers) got an error for one of the subcribers saying there is a violation of primary key constraint.
i check the data that gave the error and that data already exists on ALL subscribes.
i am clicking "start synchronizing" but it keeps coming back with that same error. help!

data was on pub & sub. thus used the Agent Profile "SKIP ERRORS" and set it = error in question. worked !

May check KBAhttp://support.microsoft.com/kb/813494 andhttp://www.replicationanswers.com/Transactional.asp link too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>