Microsoft KB Archive/310624

= BUG: DBCC DBREINDEX on Indexed View May Cause Handled Access Violation =

Article ID: 310624

Article Last Modified on 2/21/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 Q310624



BUG #: 355897 (SHILOH_BUGS)



SYMPTOMS
If you run the DBCC DBREINDEX command on a nonclustered index and the following conditions are true, it can cause a handled access violation exception in the CColumnGroupProperties::CColumnGroupProperties function of SQL Server 2000, which is reported in the SQL Server error log and terminates the client connection that ran the query.

The conditions are as follows:
 * The nonclustered index is based on an indexed view.
 * The indexed view contains an aggregate function in the select list.
 * The indexed view contains a GROUP BY clause.



WORKAROUND
If you intended to rebuild on or more of the nonclustered indexes on the indexed view (and not the clustered index), follow these steps:
 * 1) Drop the nonclustered indexes on the view.
 * 2) Re-create the nonclustered indexes on the view.

If you intended to rebuild all indexes or just the clustered index on the indexed view, follow these steps:
 * 1) Drop all nonclustered indexes on the view.
 * 2) Run DBCC DBREINDEX on the indexed view to re-create the clustered index.
 * 3) Re-create all of the nonclustered indexes on the view.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000.

Keywords: kbbug kbpending KB310624

-

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

© Microsoft Corporation. All rights reserved.