MSSQLSERVER_2546

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
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.

See Also

ALTER INDEX (Transact-SQL)
Reorganize and Rebuild Indexes