Is it possible to find disabled indexes in SQL Server 2000?

I want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?

    Requires Free Membership to View

Indexes couldn't be disabled in SQL Server 2000. The feature to disable indexes was introduced in SQL Server 2005.

This was first published in December 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.