Transactional replication failing - primary/foreign keys??

• sfollestad

  SSC Enthusiast

  Points: 164

  More actions

  September 29, 2008 at 5:31 am

  #96745

  I am trying to set up an updatable, transactional replication with 2 tables. One of the tables

  have a foreign key to the other table.

  The replication is failing with "The DELETE statement conflicted with the REFERENCE constraint "

  Does anybody know if we have to turn off the foreign key constraint at the subscriber?

  Would be really greatfull for your help 🙂

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  September 29, 2008 at 11:23 pm

  #878679

  Couldn't you make the FKs, NOT FOR REPLICATION...this would control data entered locally but not hinder the replicated data

  HTH

  Graeme