Primary key violation error in bidirectional replication

• rajesh.vr

  SSC Veteran

  Points: 278

  More actions

  July 9, 2009 at 10:07 pm

  #99779

  I setup merge replication. The primary key values are auto incremented. Actually my requirement is a bidirectional replication. The user may add data to both publisher and subcriber.The issue is, some times the primary key violation will occurr. How can i avoid this primary key violation by the use of identity range?

• hi_abhay78

  SSCertifiable

  Points: 6265

  More actions

  July 9, 2009 at 10:23 pm

  #1022847

  There is an option in some agent , i think its the merge agent .

  That option is to ignore this error .You simply have to ad the error number in the box and save it .

  Start the agent again ...you will not see that error again .

  Regards

  Abhay Chaudhary
  Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

• Kay1632

  Ten Centuries

  Points: 1148

  More actions

  June 14, 2011 at 1:52 pm

  #1338641

  What is the error number to give in -SkipError?