Post reply

nesting stored procedures

  • January 11, 2011 at 6:04 am

    #232037

    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!!!!!

  • January 11, 2011 at 7:13 am

    #1271870

    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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply