ERROR MESSAGE

Anyone have a idea about what is meant by below?
/****************************************/
Cannot roll back ken. No transaction or savepoint of that name was found.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
TRANSACTION statement is missing. Previous count = 65, current count = 66.

/****************************************************************/

Ken (klee@jeromegroup.com) writes:
> Anyone have a idea about what is meant by below?
> /****************************************/
> Cannot roll back ken. No transaction or savepoint of that name was found.
>
> Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
> TRANSACTION statement is missing. Previous count = 65, current count = 66.
>
> /****************************************************************/

The first message means that you said

ROLLBACK TRANSACTION ken

But nowhere had you ever said

BEGIN TRANSACTION ken

The second error means that you entered the transaction with a level
of no less than 65 nested transactions, and you left it with a level
of 66. This would indicate that the stored procedure said BEGIN TRANSACTION,
never committed or rolled back the transaction.

Of course, if it says

BEGIN TRANSACTION
....
ROLLBACK TRANSACTION ken
RETURN

you would get both the errors above.



--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx