In the previous article I talked about using savepoints for nested transactions. In this article will talk about how to handle rollbacks, and what to do when the Stored Procedures you use have their own transaction handling. There was a quote that I read once, I can’t remember […]

Transactions are a great way to group statements together in an all or nothing batch.However, nesting transactions is where things get a little messy, some people even call them evil. I note here that a big part of the reason people don’t like nested transactions is because they […]