FIX: AV if 4 or More Correlated Subqueries with Self-Join (153851)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbnetwork KB153851 |
|---|
|