Transaction Control ADO/Sproc

  • Hi all,

    If I was to open a TRAN within a ADO connection, and then call a Sproc within the TRAN that has its own TRAN server-side, if the Sproc's TRAN fails, does the ADO TRAN also get rolled back?

    If not, is there a solution, or should I just pick one side to run my parent TRAN?

    Thank you very much

    Maz

  • [font="Verdana"]

    ...If I was to open a TRAN within a ADO connection, and then call a Sproc within the TRAN that has its own TRAN server-side, if the Sproc's TRAN fails, does the ADO TRAN also get rolled back?...

    No. Because the failed Transaction is another transaction which is started inside the SProc. If it fails, it will Rollback only those changes taken place inside the SProc where the Transaction get started.

    Mahesh[/font]

    MH-09-AM-8694

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply