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.