InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:31:56 GMT20http://www.sqlservercentral.com/Forums/Topic889999-146-1.aspx[quote][b]GTR (3/26/2010)[/b][hr]Check this, it should answer your question[url]http://msdn.microsoft.com/en-us/library/ms189336(SQL.90).aspx[/url][/quote]This method would allow the OP to place a transaction in both stored procedures (thus nest the transactions).Fri, 26 Mar 2010 23:29:12 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic889999-146-1.aspxCheck this, it should answer your question[url]http://msdn.microsoft.com/en-us/library/ms189336(SQL.90).aspx[/url]Fri, 26 Mar 2010 15:24:19 GMTGTRhttp://www.sqlservercentral.com/Forums/Topic889999-146-1.aspxLook up Try Catch in BOL. That will help you with being able to rollback the transaction.Thu, 25 Mar 2010 10:42:59 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic889999-146-1.aspxHi, I have this stored procedure: create stored procedure testasBegin update table xtu set cod ='A'Endif i execute this stored procedure from inside other stored procedure, like this:create procedure test2asBEGINdeclare @erro as intbegin transactionexec testset @erro =@@errorif @erro =0begincommit transactionendelserollback transactionENDIf i get an error when executing the procedure test can i rollback the transaction that was made by the procedure test? or should i place a BEGIN TRANSACTION and COMMIT TRANSACTION inside the stored procedure test , so that i can rollback transaction from within procedure test2 if procedure test fails?Thank youThu, 25 Mar 2010 10:39:52 GMTriver1