FIX: Server Stops/AV on Client Disconnect w/ an Open Transaction

Last reviewed: June 27, 1997
Article ID: Q166188

The information in this article applies to:

Microsoft SQL Server, versions 6.5 Service Pack 1 and Service Pack 2

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 Microsoft SQL Server version 6.5 Service Pack 1 and 2. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact yourprimary support provider.

Additional query words: hang hung crash crashed gpf unhandled exception
Keywords : kbbug6.50 SSrvGPF buglist1.0x
Version : 6.5
Platform : WINDOWS
Issue type : kbbug
Resolution Type : kbfix

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.