Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 2530 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | DBCC_INDEX_IS_OFFLINE |
| Message Text | The index "%.*ls" on table "%.*ls" is disabled. |
Explanation
The DBCC statement cannot proceed because the specified index is disabled. After an index is disabled, it remains in a disabled state until it is rebuilt or dropped and re-created.
User Action
Enable the disabled index by using one of the following methods:
ALTER INDEX statement with the REBUILD clause
CREATE INDEX with the DROP_EXISTING clause
DBCC DBREINDEX
Rerun the DBCC statement.
See Also
Enable Indexes and Constraints
ALTER INDEX (Transact-SQL)
CREATE INDEX (Transact-SQL)
DBCC DBREINDEX (Transact-SQL)