FIX: AV When Creating Reformat Plan of SP Containing JoinLast reviewed: May 1, 1997Article ID: Q136844 |
The information in this article applies to:
SYMPTOMSA thread-level access violation (AV) can happen during creation of the access plan of a stored procedure if the query involves three or more tables, two of which are temporary tables.
CAUSEThis problem does not always happen, but only with certain statistical distributions of data which cause the optimizer to build a reformat access plan.
WORKAROUNDThere are three possible ways to avoid this problem.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.
|
Additional query words: sql6 sproc optimization
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |