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

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s