nesting stored procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » nesting stored procedures

nesting stored procedures

Rate Topic

Display Mode

Topic Options

Author

Message

hemanth T

Posted Tuesday, January 11, 2011 6:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 30, 2012 7:58 AM
Points: 35, Visits: 122

hi all,
when i tried to execute two nesting levels of stored procedures
example:

exec proc1

proc1(----)as
begin

exec proc2
end

proc2(----)
begin
exec proc3
end

proc3(---)

i got an error like this

Cannot roll back WORKFLOW. No transaction or savepoint of that name was found.

error 6401

can anyone help me out!!!!!

Post #1045840

Grant Fritchey

Posted Tuesday, January 11, 2011 7:13 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:04 PM
Points: 13,375, Visits: 25,159

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

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1045888

« Prev Topic | Next Topic »

Permissions