The information in this article applies to:
BUG #: 18406 (SQLBUG_65) SYMPTOMS
A query may disconnect the client process from the server if all of the
following conditions are true:
In both instances, a handled exception access violation (AV) stack will be written to the SQL Server error log. WORKAROUND
To work around this problem, do any one of the following:
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 6.5 Service Pack 2 and later. MORE INFORMATION
This problem appears to be related to the issue described in the following
article in the Microsoft Knowledge Base:
Q181923 : SELECT with Many Columns Causes Handled AV in Optimizer But the stack trace generated is different, and in this instance there will be no mention of EXCEPTION_INT_DIVIDE_BY_ZERO, as in that case. However, in light of the issue described in that article, it would be best to keep the total number of bytes-per-row returned less than 2,000. Additional query words:
AV maximum freeze hang hangs hung errorlog err
Keywords : SSrvTran_SQL kbbug6.50.sp2 kbbug6.50.sp3 kbbug6.50.sp4 |
Last Reviewed: April 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |