SQLServerCentral / SQL Server 2005 / SQL Server 2005 General Discussion / nesting stored procedures / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:28:51 GMT20RE: nesting stored procedureshttp://www.sqlservercentral.com/Forums/Topic1045840-149-1.aspxIt sounds like you have a transaction rollback within one of the procedures, but no begin transaction statement. You have to either add a begin trans statement or remove the rollback.Tue, 11 Jan 2011 07:13:50 GMTGrant Fritcheynesting stored procedureshttp://www.sqlservercentral.com/Forums/Topic1045840-149-1.aspxhi all,when i tried to execute two nesting levels of stored proceduresexample:exec proc1proc1(----)asbegin exec proc2endproc2(----)beginexec proc3endproc3(---)i got an error like this Cannot roll back WORKFLOW. No transaction or savepoint of that name was found.error 6401can anyone help me out!!!!!Tue, 11 Jan 2011 06:04:38 GMThemanth T