Replication failed

  • We got the error Replication failed with primary key vioaltion at the subscriber end ?

    what are the reasons for this and how to solve it?

  • Check the table and its dependent objects. One of the objects in your replication set up would have missed.

  • The replication agent is trying to insert a duplicate primary key at the subscriber.

    You will need to remove the row that was inserted at the publisher to resolve the error.

    If the table contains an identity column, you may want to consider automatic identity range management and/or marking the identity column as NOT FOR REPLICATION.

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

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