Microsoft KB Archive/159937

= FIX: AV Creating View With ANSI JOINS =

Article ID: 159937

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Service Pack 1

-



This article was previously published under Q159937



BUG #: 15781 (Windows: 6.50 SP1)



SYMPTOMS
When you create views containing ANSI standard joins, the DB-Library process may fail, and break the connection. A handled access violation (AV) is generated in the error log. This problem is most commonly seen with nested ANSI joins, where the inner join is a CROSS JOIN.



WORKAROUND
To work around this problem, do not use ANSI-Standard joins.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 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.



MORE INFORMATION
Nested ANSI Joins worked properly in the Microsoft SQL Server 6.5. Service Pack 2 restores the functionality that was lost in Service Pack 1.

Additional query words: AV ANSI VIEWS JOIN CROSSJOIN SP1

Keywords: kbbug kbfix kbusage KB159937

-

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

© Microsoft Corporation. All rights reserved.