FIX: AV Creating View With ANSI JOINS

ID: Q159937

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 1 and later

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          : kbusage SSrvDB_Lib SSrvErr_Log kbbug6.50.sp1 kbfix6.50.sp2 
Version           : SP1
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999