Sorry for the length of this. I'm trying to condense some general toughts on this topic before coming to the actual issue towards the end. Let me try to outline a hierarchy of constraints in order of ...

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or ...