Wednesday, March 7, 2012

call sp_MSget_repl_commands(29, ?, 0, 7500000)

any idea why i'm getting this error on replication?
call sp_MSget_repl_commands(29, ?, 0, 7500000)
Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__2813BD1E'.
Cannot insert duplicate key in object '#271F98E5'.One of the target objects (being replicated) already has a row that replication is trying to insert. That is a bad thing.

You need to discover which object is complaining, and what row is being inserted. Look at the replication tasks, in the job history to see the details of the problem.

-PatP

No comments:

Post a Comment