Retrieve Index Status of a table

muralidharan.d · May 20th, 2008, 02:27 AM

Hi All,

I want to know the status of an index whether it is corrupted or it needs to be reindexed etc ?

I used the sp_MShelpindex tablename stored procedure to retrieve the status also.

In the status column it is showing as 0,2 and 2000 values . what are these values ?

Thanks

Murali

With Regards,
Muralidharan.D

SQLScott · June 6th, 2008, 04:13 PM

Since this is an undocumented stored procedure, your chances of finding out what these values mean are probably slim to none.

Did you try sys.dm_db_index_physical_stats?

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================