The information in this article applies to:
BUG# NT: 911 (4.21 - NTAlpha) SYMPTOMS
On Microsoft SQL Server for Windows NT on DEC Alpha, a stored procedure may
cause an access violation that terminates the client process if it selects
based on IN or NOT IN criteria from a subquery returning a DISTINCT result
column and with SQL Server's memory setting set to approximately 5120 pages
or higher.
WORKAROUND
Run the SELECT outside of a stored procedure, or change the subquery
to the following:
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.21 for Windows NT on DEC Alpha. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
The follow query duplicates this problem when SQL Server's memory is more
than 5120 pages:
Keywords : kbprg SSrvRISC SSrvStProc kbbug4.21 SSrvWinNT |
Last Reviewed: March 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |