BUG: Transaction Names Are Case Sensitive on a Non-Case-Sensitive SQL Server (282827)

The information in this article applies to:

Microsoft SQL Server 7.0
Microsoft SQL Server 2000 (all editions)

This article was previously published under Q282827

BUG #: 101101 (SQLBUG_70)
BUG #: 351524 (SHILOH)

SYMPTOMS

When you attempt to roll back a named transaction, but spell the transaction name using a different case, you may receive the following error message:

Server: Msg 6401, Level 16, State 1, Line 2
Cannot roll back tran1. No transaction or savepoint of that name was found.

WORKAROUND

Assume case sensitivity when you roll back named transactions.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0 and 2000.

MORE INFORMATION

The following script demonstrates that transaction names are case sensitive on a default install, which is not case sensitive.

BEGIN TRAN Tran1
ROLLBACK TRAN tran1

If you change the ROLLBACK TRAN statement from "tran1" to "Tran1", the script works as expected.

Modification Type:	Major	Last Reviewed:	10/16/2003
Keywords:	kbbug kbpending KB282827