The DELETE statement conflicted with the REFERENCE constraint

• J-Hob

  SSC-Addicted

  Points: 425

  More actions

  July 26, 2007 at 5:36 am

  #153709

  Hi there,

  I am getting the error 'The DELETE statement conflicted with the REFERENCE constraint' on trying to delete a record from one of my tables. I understand why I am getting this error message and I have set the on cascade delete for all relationships in the database.

  I have also set 'enforce foreign key constraint' to 'No' and still it won't let me delete the record.

  There is clearly something missing in my knowledge of how SQL Server 2005 works here, could someone enlighten me please?

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  July 27, 2007 at 4:55 am

  #722816

  Hi

  Are you sure you have set the On Delete cascade correctly everywhere its required.

  Are there any circular reference anywhere in this chain or any triggers.

  "Keep Trying"

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  July 27, 2007 at 7:38 am

  #722865

  Check if any trigger is getting fired. !!

  "More Green More Oxygen !! Plant a tree today"