MSSQLSERVER_2546
New: 14 April 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1281.60 |
Event ID |
2546 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
DBCC_INDEX_MARKED_DISABLED |
Message Text |
Index 'INDEX_NAME' on table 'OBJECT_NAME' is marked as disabled. Rebuild the index to bring it online. |
Explanation
The specified index is marked as offline or is disabled. Therefore, this index cannot be checked.
User Action
Rebuild the index by using ALTER INDEX or DBCC DBREINDEX.
See Also
Other Resources
ALTER INDEX (Transact-SQL)
DBCC DBREINDEX (Transact-SQL)
Reorganizing and Rebuilding Indexes