BUG: DBCC DBREINDEX on Indexed View May Cause Handled Access Violation (310624)


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 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.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbbug kbpending KB310624
©2004 Microsoft Corporation. All rights reserved.