FIX: AV When Creating Reformat Plan of SP Containing Join

Last reviewed: May 1, 1997
Article ID: Q136844

The information in this article applies to:
  • Microsoft SQL Server, version 6.0
BUG# NT: 10300 (6.00)

SYMPTOMS

A 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.

CAUSE

This problem does not always happen, but only with certain statistical distributions of data which cause the optimizer to build a reformat access plan.

WORKAROUND

There are three possible ways to avoid this problem.

  1. Create the temporary tables within the stored procedure.

  2. Use permanent tables instead of temporary tables.

  3. Use an optimizer hint on the temporary tables to force a table scan. See the SQL Server version 6.0 documentation for details on using optimizer hints.

STATUS

Microsoft 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
Keywords : kbbug6.00 kbfix6.00.sp1 kbprg SSrvProg SSrvStProc
Version : 6.0
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 1, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.