How to fix Error 1973 on Windows Server 2025 / Windows 11

by

Troubleshooting Guide: SQL Server Error 1973 – “Cannot Perform the Specified Operation on Disabled Index”

Why This Error Happens

This error occurs when an application or query attempts to perform an operation—such as a SELECT, INSERT, UPDATE, or DELETE—on a table or view whose index has been explicitly disabled using the ALTER INDEX ... DISABLE statement. SQL Server 2025 blocks access to the underlying data structure because a disabled clustered index renders the entire table unavailable until it is rebuilt. This typically happens after a maintenance script, a failed migration, or an index reorganization task disables an index but does not execute the subsequent rebuild step.

Step-by-Step Resolution Guide

Step 1: Identify the Disabled Index

  • Open SQL Server Management Studio (SSMS) connected to your Windows Server 2025 instance.
  • Run the following query to locate the specific disabled index mentioned in the error message:
  SELECT name, is_disabled, object_id 
  FROM sys.indexes 
  WHERE is_disabled = 1;
  • Note the exact index name and the parent table/view referenced in the error (%.*ls).

Step 2: Rebuild the Disabled Index

  • Execute a rebuild command to restore the index and make the table accessible again. This is the most common fix:
  ALTER INDEX [IndexName] ON [SchemaName].[TableName] REBUILD;
  • If the index is a clustered index, ensure there is enough free space in the database, as a rebuild requires additional space temporarily (roughly equal to the size of the existing index).

Step 3: Check for Insufficient Permissions or Resource Governor Limits

  • If the rebuild fails, verify the executing account has ALTER permission on the object.
  • On Windows Server 2025, check the Resource Governor settings via sys.resource_governor_workload_groups to ensure the maintenance session isn’t being throttled, which can cause rebuild timeouts.

Step 4: Script and Rebuild All Indexes (If Multiple Objects Fail)

  • If the error affects multiple objects after a mass disable operation (common during version upgrades to SQL Server 2025), generate a dynamic script to rebuild all disabled indexes at once:
  DECLARE @sql NVARCHAR(MAX) = N'';
  SELECT @sql += 'ALTER INDEX [' + i.name + '] ON [' + s.name + '].[' + t.name + '] REBUILD;' + CHAR(13)
  FROM sys.indexes i
  JOIN sys.tables t ON i.object_id = t.object_id
  JOIN sys.schemas s ON t.schema_id = s.schema_id
  WHERE i.is_disabled = 1;
  EXEC sp_executesql @sql;
  • Review the output to ensure every disabled index was successfully recreated.

Alternative or Verification Steps

  • Verify the Fix: Re-run the original query or application transaction that triggered Error 1973. The operation should now complete without the disabled index error.
  • Alternative Solution: If rebuilding fails due to corruption (rare but possible on Windows Server 2025 volumes), drop the index entirely using DROP INDEX and recreate it from scratch using the original CREATE INDEX definition found in your database schema documentation.