mtassin (9/15/2010)
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
Hey, Mark!
That's really good to know!
Coincidence is a great phenomenon - I wonder how they happen?
Have a wonderful rest-of-the-week ahead!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins