Post reply

Transaction Control ADO/Sproc

  • May 15, 2008 at 12:14 pm

    #125350

    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

  • May 16, 2008 at 6:52 am

    #816435

    [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