<p>I want to create a trigger to check what is being deleted against business rules and then cancel the deletion if needed. Any ideas?</p>

<p>The solution used the Instead of Delete trigger. The Rollback tran stopped the delete. I was afraid that I would have a cascade issue when I did the delete but that didn't seem to happen. Maybe a trigger cannot trigger itself.</p>

Use an
```
INSTEAD OF DELETE
```
(see
MSDN
) trigger and decide within the trigger what you really want to do.