Accessing The INSERTED And DELETED Pseudo-Tables In A Trigger’s CATCH Block

At work recently, we had a scenario come up in which we wanted to figure out which specific values are causing a trigger to roll back execution of a stored procedure.  I decided to put together a test case to see if I could still access the DELETED pseudo-table from within a trigger's CATCH block.  It…

Advertisement