Groups | Blog | Home
all groups > sql server replication > may 2007 >

sql server replication : transactional replication with nosync init ..delete statement conf


BaniSQL
5/15/2007 3:52:01 AM
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?

Thanks a lot,
Paul Ibison
5/15/2007 7:27:39 PM
This flag only works for singletons - is it possible that the new updates
which cause delete/insert pairs result from an update affecting multiple
rows?
Rgds,
Paul Ibison

AddThis Social Bookmark Button