Replication Error

• Rechana Rajan

  SSCertifiable

  Points: 7721

  More actions

  July 23, 2011 at 8:06 am

  #240385

  We are facing replication issue in one of our server.

  The server is copnfigured for transaction replication.

  From distributor to Subscriber its throwing error

  Error messages:

  There are no primary or candidate keys in the referenced table 'Masters' that match the referencing column list in the foreign key 'FK_Child_Masters'. (Source: MSSQLServer, Error number: 1776)

  Get help: http://help/1776

  There are no primary or candidate keys in the referenced table 'Masters' that match the referencing column list in the foreign key 'FK_Child_Masters'. (Source: MSSQLServer, Error number: 1776)

  Get help: http://help/1776

  Could not create constraint. See previous errors. (Source: MSSQLServer, Error number: 1750)

  Get help: http://help/1750

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2011 at 9:57 am

  #1357430

  Duplicate post:

  http://www.sqlservercentral.com/Forums/Topic1147059-146-1.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/