Transaction Control ADO/Sproc

• mboddoo

  SSC-Addicted

  Points: 464

  More actions

  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

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  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