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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s