title: How do I cancel a Delete in SQL
body: <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>