June 18, 2003 at 7:39 pm
Merge repl sql 2k sp2
Doing a delete on a table. Receive the following error:
Cannot insert duplicate key row in object 'MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone'.
I have tried 2 things, neither successful:
*sp_mergecleanupmetadata
*identifying any rows in msmerge_tombstone that have a tablenick that matches the nickname in sysmergearticles - then deleted the row from tombstone.
I am on a quest to figure this out without dropping any replication objects. I have been successful in most cases but this one has me a little confused. Any thoughts?
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
June 18, 2003 at 7:42 pm
One other thing...I have noticed that msmerge_tombstone on the publisher and subscriber have a different number of records. Is that normal...I would assume not.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply