Cannot perform the specified operation on disabled index

my maintenance plan for defrag-ing indexes was failing due to a disabled index

ran this to re-enable index:

ALTER INDEX [indexname] ON dbname.tablename REBUILD
GO

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.