HELp ! | SQL Server Performance Forums

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 KBA and link too. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.