Home Forums SQL Server 2005 SQL Server 2005 General Discussion Ideas about Error 266 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0." RE: Ideas about Error 266 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0."

  • November 18, 2010 at 4:36 am

    #1252390

    Another option is to not nest transactions. Have a single point of control.

    i.e. only the level that starts the transaction commits or rolls back.


    Cursors never.
    DTS - only when needed and never to control.