One thing you can do is change the trigger from INSTEAD OF DELETE to FOR DELETE.

An INSTEAD OF trigger executes the code in place of the requested operation, and it...