Microsoft KB Archive/157809

= FIX: AV Caused by View with Distinct and Correlated Subquery =

Article ID: 157809

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q157809



BUG#: 15644 (SQL 6.0) 15964 (SQL 6.5)



SYMPTOMS
Selecting from a view that contains a correlated subquery and a distinct clause can cause a thread level access violation (AV) in SQL Server.



WORKAROUND
Recode the query so that a distinct clause and a correlated subquery are not combined.



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

Additional query words: default

Keywords: kbbug kbfix kbother KB157809

-

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

© Microsoft Corporation. All rights reserved.