FIX: AV Creating View With ANSI JOINS (159937)
The information in this article applies to:
- Microsoft SQL Server 6.5 Service Pack 1 and later
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbusage KB159937 |
|---|
|