November 16, 2003 at 11:51 pm
Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__20A2B0EA'. Cannot insert duplicate key in object '#1FAE8CB1'.
vijay
vijay
November 19, 2003 at 8:00 am
This was removed by the editor as SPAM
November 19, 2003 at 10:45 am
I've got an article posted on the site that talks about that a little. Typically happens when someone inserts a row on the subscriber by mistake, then inserts it on publisher. Easiest fix is to find the problem record, delete from subscriber, restart the agent.
Andy
November 26, 2003 at 6:56 am
If found that error in my publishers tipically when a subscribe a server with applying the snapshot. I mean @sync_type = 'none'.
I read somewhere that it is a bug and there is a fix for it, but I've never installed it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply