BUG: DBCC DBREINDEX Can Cause Error 8623 on Indexed View (310714)


The information in this article applies to:

  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
This article was previously published under Q310714
BUG #: 355904 (SHILOH_BUGS)

SYMPTOMS

The DBCC DBREINDEX statement can cause the following error:
Error 8623, Level 16, State 5, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.
This error can occur when all of the following conditions are met:
  • You run DBCC DBREINDEX on an indexed view without the optional index name parameter.
  • The indexed view also has a nonclustered index built on it.
  • The SQL Server 2000 instance is running on hotfix build 8.00.426 or later.

WORKAROUND

Use the optional index name parameter when using DBCC DBREINDEX on an indexed view.

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000 hotfix build 8.00.426, or later.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbbug kbpending KB310714
©2004 Microsoft Corporation. All rights reserved.