none
All Foreign Keys are disabled after turning on replication. RRS feed

  • Question

  • We recently added a SQL server to mirror our production database.  Now we have 2 servers and the live database shows as (Synchronized).  A user reported a problem and we realized ALL the FOREIGN KEYS CONSTRAINTS in the database had been disabled (Enforce Constraint = No, Enforce for Replication = Yes). 

    How could this happen? 

    Production settings for foreign keys should be; Enforce Constraint = Yes and Enforce for Replication = No, correct? 

    Thanks in advance,

    Mike

    Tuesday, November 26, 2019 11:26 PM

All replies