FIX: DBCC DBREINDEX on a Table Without any Indexes Creates Error (233522)
The information in this article applies to:
This article was previously published under Q233522
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 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix KB233522 |
|---|
|