Retrieve Index Status of a table
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 ?