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

• Microsoft SQL Server version 6.5 Service Pack 2 and later

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          : SSrvGPF kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 9, 1999