Microsoft KB Archive/153851

= FIX: AV if 4 or More Correlated Subqueries with Self-Join =

Article ID: 153851

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q153851





SYMPTOMS
If a complex query does a self-join and has four or more subqueries, all referencing the same table, it may get a thread-level access violation (AV) if the table has only a non-clustered index.



WORKAROUND
Convert the non-clustered index to a clustered index, or drop it.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.50.201. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: sp1 default

Keywords: kbbug kbfix kbnetwork KB153851

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.