Hi All,

I have several stored procedures that have nested SP calls. I want to make sure all transactions are rolled back in case of an error along the way. Where each separate SP may have a BEGIN TRAN statement...

What is the best way to handle @@ERROR when one SP may call another SP?

TIA,
Mike