Foreign key failure with Merge Replication

• sonya_sml

  Grasshopper

  Points: 17

  More actions

  January 11, 2010 at 10:50 am

  #103876

  I have two table with primary key and foreign key relationship. Both the

  tables have primary key with Uniqueidentifier column. First uniqueidnetifer

  column is mapped to second table as Foregein key.

  Sometimes, the process of insertion is like first inserting foreign

  key table then primary key table. As a result conflict arises and data is rolledback.

  I have been asked to set the property of this specific field as 'Not for replication'.

  How can i do that without disturbing the current replication. I need to do it through script.

  Thanks

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  February 5, 2010 at 8:10 am

  #1114469

  You can drop and reapply FKs while replication is running although I would stop all the agents while you re-apply.

  You can drop the FKs and reapply with the NOT For Replication setting.

  HTH

  Graeme