Microsoft KB Archive/282827

= BUG: Transaction Names Are Case Sensitive on a Non-Case-Sensitive SQL Server =

Article ID: 282827

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;tran1&quot; to &quot;Tran1&quot;, the script works as expected.

Keywords: kbbug kbpending KB282827

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.