Try and catch RRS feed

  • Question

  • Hi I use Try catch and transactions in one of my stored procedures.

    Inside I make a call to another stored procedure.

    Is it possible to roll back the outer sp?

    Please advise.
    Thursday, May 22, 2008 7:39 AM

All replies

  • Yes.


    Within nested transaction, ROLLBACK TRAN will rollback all transactions, up to outmost level.

    If you want to rollback only part of transaction, you must use savepoint. And rollback to that save point.






    Thursday, May 22, 2008 8:35 AM