Hi Samuel,

Quote Originally Posted by Samuel Pizarro View Post
in your Sql-Studio tests, did you surround your sp call with a outer transaction as well ?
A good point. And now that I've tried this I get the same error.

Looks like ROLLBACK doesn't decrement the @@TRANCOUNT but treats the entire transaction as if it had failed, resetting it back to 0, irrespective the level of nesting.

This isn't what I was expecting.