We have replication set up with a two tree model and just started
receiving the following error:
23000[Microsoft][ODBC SQL Server Driver][SQL Server]DELETE statement
conflicted with COLUMN REFERENCE constraint 'FKSic_Synonyms'. The
conflict occurred in database 'ABI', table 'Sic_Synonyms', column 'sic'
We have Trace Flag 8202 enabled on all servers to make the Logreader
replicate all UDPATE commands as
DELETE/INSERT pairs at the subscriber.
We've had to drop our FK's on the subscribers, but is there a work
around for this?
Thanks in advance.