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)
 Replication deletes records through relationship configuration

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-31 : 22:36:05
Paul writes "I have a large database 200 tables (Small Data Volume) which needs to replicate all but 1 table nightly.
When I made the publication all relationships default to the "Enforce Relationship for Replication".
This causes records to get deleted, unless I remove it.
What is the reason for tis and is there an easy way to remove them all ?"
   

- Advertisement -