How can I fix a corruption in a system table?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. A. If the problem can be fixed with an index re-create, then there is a system stored-procedure to do this.

sp_fixindex ,,
e.g. sp_fixindex pubs,sysindexes,2

You can also issue the relevant dbcc command directly if sp_fixindex refuses to attempt the fix - e.g. for a non-clustered index on sysobjects

DBCC DBREPAIR(dbid, REPAIRINDEX, sysobjects, 2)

It is not possible to rebuild the clustered index on sysindexes or sysobjects.

If the above do not work, then the only choice is to create a new database and then use the transfer tools in SQL EM to copy the good data and objects across.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like