SQL Server Performance Forum – Threads Archive
Trans, Repl Err : COLUMN REFERENCE
DELETE statement conflicted with COLUMN REFERENCE constraint ‘FK_moviecats_cats’.
With trans repl and DRI enabled, I get the above error once and a while.
It seems as if replication is not deleting the rows from tables in proper order so that this doesn’t happen. Edit: Enforce relationship for replication is on as well SQL2K on Win2K3 http://onmyword.com
this was a bug in SQL Server 7.0
http://search.support.microsoft.com/kb/240192 but you are saying this is on SQL Server 2000.
Actually SQL Server 2000 select order of replication by analysing these foreign keys. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
I thought so too,
I’ve re-created the publication and I’ll see if it keeps going on.
——————————–
http://onmyword.com
hope that will work. I will give you the system table that you should look for to view the replication sequence later. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
unfortunately, the same error
does anyone have a definitive description about this:
‘Enforce relationship for replication’ I’ve found BOL horrible on this topic ——————————–
http://onmyword.com
http://msdn2.microsoft.com/en-us/library/5zs4632b(vs.80).aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Enforce relationship for replication— This tells SQL Server to enforce the relation when replicating data. Unless you will be using replication, this is of no concern to you. If you are using replication, you may want to turn this off if you define a relationship after a table that is in. With this off, SQL Server will not check DRI rules when synchronizing databases. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>