Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Disable "enforce relationship for replication"

Author  Topic 

mattharris5
Starting Member

1 Post

Posted - 2007-08-17 : 14:30:53
Is it possible to disable the "enforce relationship for replication" option without reinitializing the subscriptions? I have a scenario where it is not easy for me to deploy new snapshots because the replication takes place over the Internet, but when the subscriptions were setup, they had the "enforce" option enabled. This is causing data to be deleted when synchronizing because of the foreign key constraints. Is there a stored procedure or something that can allow me to disable this option?

-Matt
   

- Advertisement -