Transaction Control ADO/Sproc

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Transaction Control ADO/Sproc

Transaction Control ADO/Sproc

Rate Topic

Display Mode

Topic Options

Author

Message

mboddoo

Posted Thursday, May 15, 2008 12:14 PM

Grasshopper

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

Mahesh Bote

Posted Friday, May 16, 2008 6:52 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:22 AM
Points: 1,074, Visits: 1,205

...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 »

Permissions