Article ID: 160584
Article Last Modified on 10/16/2003
APPLIES TO
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q160584
BUG #: 15657 (Windows NT: 6.0) 16163 (6.5)
SYMPTOMS
If a transaction is rolled back in a 'single user' database, a Msg 3307 error will occur, followed by a handled access violation. The server will stop responding, and no connections or queries will be allowed into the server at this point.
WORKAROUND
To work around this problem, avoid rolling back transactions in a 'single user' database.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
MORE INFORMATION
When this problem occurs, the following type of error information is returned to the client application (specific process and page information will likely be different for each scenario):
The following error information is written to the SQL Server errorlog:
This problem may occur if the transaction is rolled back explicitly using the ROLLBACK command, or if the client connection is terminated before the transaction can be committed. SQL Server may stop responding under this scenario, and cannot be shut down normally as a service. If the server was started from the command line, it may be possible to shut it down by using a CTRL+C key sequence. In either case, when the server is restarted, this transaction should be properly rolled back by recovery.
Additional query words: freeze lock up lockup frozen hang hung
Keywords: kbbug kbfix kbusage KB160584