Violation of PRIMARY KEY constraint in Replication

  • Violation of PRIMARY KEY constraint 'PK_table_access_id'. Cannot insert duplicate key in object 'dbo.table_access_id'. The duplicate key value is (268435492, 1). (Source: MSSQLServer, Error number: 2627)

    Get help: http://help/2627

    Can any one please help how to get sequence numbers to check in sp_browsereplcmd?

  • Is this error on the subscriber?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • there must be some other process on the subscriber which might have inserted that row. Try to delete that row from the subscriber after saving the data. The replication should re insert that row.

  • phani404 (10/21/2013)


    Violation of PRIMARY KEY constraint 'PK_table_access_id'. Cannot insert duplicate key in object 'dbo.table_access_id'. The duplicate key value is (268435492, 1). (Source: MSSQLServer, Error number: 2627)

    Get help: http://help/2627

    Can any one please help how to get sequence numbers to check in sp_browsereplcmd?

    Is that a identity column?

    Regards
    Durai Nagarajan

Viewing 4 posts - 1 through 3 (of 3 total)

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