SQL Server Delete Trigger - Row Handle Referred To A Deleted Row Or A Row Marked For Deletion

I have a delete trigger on a table which is used to delete entries from a table in an another database. CREATE TRIGGER [dbo].[Trigger_Contracts_Delete] ON [dbo].[Contracts] AFTER

Solution 1:

your table(s) are missing primary keys! add primary keys and the problem will go away.

Solution 2:

If you alawys want to delete the records from the child table, why not set up cascading delte instead of a trigger?