How can I fix a corruption in a system table?
Neil Pike
March 4, 1999
1 Min Read
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.
About the Author
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