Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transaction Control ADO/Sproc Expand / Collapse
Author
Message
Posted Thursday, May 15, 2008 12:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 11, 2009 2:21 PM
Points: 12, Visits: 67
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
Post #501561
Posted Friday, May 16, 2008 6:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:57 AM
Points: 1,093, Visits: 1,222
...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


MH-09-AM-8694
Post #502001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse