MSSQLSERVER_2546

Applies to: SQL Server

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