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
 General SQL Server Forums
 Database Design and Application Architecture
 transactional replication with nosync init ..delet

Author  Topic 

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-15 : 07:32:41
Hi,
I'm having problem which previously was solved by enabling flag 8207, but now again even with this trace flag 8207 setting On the error I'm getting again (DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__).
The only change is that the new server where I have re-setup the replication is CLUSTER machine. It's vitrual sql server 2000 Enterprise edition installed. Can Cluster service of Windows OS be the reason? Is something additionally that has to be done for Cluster server for the transactional replication?

Thanks a lot,
BaniSQL
   

- Advertisement -