SQL Server Performance

Trans, Repl Err : COLUMN REFERENCE

Discussion in 'Performance Tuning for SQL Server Replication' started by ginoitalo, Nov 22, 2006.

  1. ginoitalo New Member


    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
  2. dineshasanka Moderator

  3. ginoitalo New Member

    I thought so too,
    I've re-created the publication and I'll see if it keeps going on.


    --------------------------------
    http://onmyword.com
  4. dineshasanka Moderator

    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/
  5. ginoitalo New Member

    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
  6. dineshasanka Moderator

    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/
  7. satya Moderator

    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.

Share This Page