Post reply

Violation of PRIMARY KEY constraint 'PK__@snapshot

  • November 16, 2003 at 11:51 pm

    #83198

    Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__20A2B0EA'. Cannot insert duplicate key in object '#1FAE8CB1'.

    vijay


    vijay

  • November 19, 2003 at 10:45 am

    #482709

    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

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • November 26, 2003 at 6:56 am

    #483721

    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 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply