I don't even know how excitingly appropriate this is.

Yesterday I learned about savepoints. Today a trigger that was invoking a stored procedure that created an inner transaction and rolled it back if a test case was pushed into production.

Nobody could figure out why the table with the tirgger was never getting a record.

Stuck in a transaction save point right after the BEGIN TRANSACTION in the stored proc and set the ROLLBACK to rollback to the savepoint and made the problem go away.

Awesome