Microsoft KB Archive/310714

= BUG: DBCC DBREINDEX Can Cause Error 8623 on Indexed View =

Article ID: 310714

Article Last Modified on 2/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise 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.

Keywords: kbbug kbpending KB310714

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.