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.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2013-01-31 : 07:13:32
|
| Hi, Recently i published a sql server 2000 database. And started getting conflicts. I came to know that if referential integrity settings on replication is causing this problem. But i dont have idea what is this setting and where to set? Anyone has idea about this?Thanks in advance,Aradhya |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-01-31 : 10:41:34
|
| Assuming the subscribers are read only ie not merge replication - Typically when you set up your article properties of the publication you would set the "replicate Foreign Key Constraints" to false. Bottom line is the subscriber tables should not have foreign keys.Be One with the OptimizerTG |
 |
|
|
|
|
|
setting referential integrity on replication