FIX: Server Stops/AV on Client Disconnect w/ an Open Transaction (166188)
The information in this article applies to:
- Microsoft SQL Server 6.5 Service Pack 1
- Microsoft SQL Server 6.5 Service Pack 2
This article was previously published under Q166188
BUG #: 16290 (Windows NT: 6.5)
SYMPTOMS
When a client disconnects without a commit or a rollback on a transaction
involving a global temporary table, and if the temporary table is being
accessed by another client, it generates an access violation (AV) and the
server stops responding. When this happens, the MSSQLServer service is not
controllable using Service Control Manager functions, and must be closed by
using Windows NT Resource Kit utilities or by shutting down Windows NT.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in U.S.
Service Pack 3 for Microsoft SQL Server version 6.5. For more information,
contact your primary support provider.
| Modification Type: | Minor | Last Reviewed: | 2/22/2005 |
|---|
| Keywords: | kbBug kbfix KB166188 |
|---|
|