FIX: DBCC DBREINDEX on a Table Without any Indexes Creates Error

ID: Q233522

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 54226 (SQLBUG_70)

SYMPTOMS

When you run DBCC DBREINDEX on a table that does not have any indexes, you will see the following error message:

Server: Msg 7934, Level 16, State 2, Line 1
The table <table_name> has no indexes.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: reindex err noindex

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug