Could not find any index named XXX for table XXX

A regular index maintenance Job we run started returning an error …

Msg 7999, Level 16, State 40, Line 1
Could not find any index named ‘index_name’ for table ‘table_name’.

… the fix was to drop the statistics for the non-existent index …

drop statistics table_name.index_name

Leave a comment