Solving the SQL Server Multiple Cascade Path Issue with a Trigger

This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.