How to Fix a Corrupted Index on System Tables

If the index on one of your system tables has been corrupted, you can use the sp_fixindex stored procedure to repair the index.

WARNING! Do not run sp_fixindex on the clustered index of the sysobjects or sysindexes tables or on user tables. Read the following section for these and other important warnings.