The information in this article applies to:
BUG #: 16361 (Windows NT: 6.5) SYMPTOMS
You may receive a handled access violation (AV) when you attempt to select
from a view that was created with a DISTINCT clause, and there is a natural
JOIN between base tables inside a stored procedure.
WORKAROUND
To work around this problem, place the SELECT statement of the stored
procedure inside an EXEC() statement.
Change the statement to:
Otherwise, move the query outside of the stored procedure, or avoid using the DISTINCT keyword in the view definition. STATUSMicrosoft 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 your primary support provider. Additional query words: SP1 SP2
Keywords : kbusage SSrvStProc SSrvTran_SQL kbbug6.50.sp1 kbbug6.50.sp2 |
Last Reviewed: April 7, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |