Skip to content

Latest commit

 

History

History
36 lines (30 loc) · 1.04 KB

mssqlserver-2546-database-engine-error.md

File metadata and controls

36 lines (30 loc) · 1.04 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
MSSQLSERVER_2546
MSSQLSERVER_2546
MashaMSFT
mathoma
04/04/2017
sql
supportability
reference
2546 (Database Engine error)

MSSQLSERVER_2546

[!INCLUDE 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