Running sp_fixindex to repair a nonclustered index on sysobjects requires several additional steps.
Perform steps 1–3, as described above.
Issue the following Transact-SQL query:
1> use database_name 2> go
1> checkpoint 2> go
1> select sysstat from sysobjects 2> where id = 1 3> go
Save the original sysstat value.
Change the sysstat column to the value required by sp_fixindex:
1> update sysobjects 2> set sysstat = sysstat | 4096 3> where id = 1 4> go
Run sp_fixindex:
1> sp_fixindex database_name, sysobjects, 2 2> go
Restore the original sysstat value:
1> update sysobjects 2> set sysstat = sysstat_ORIGINAL 3> where id = object_ID 4> go
Run dbcc checktable to verify that the corrupted index is now fixed.
Disallow updates to system tables:
1> sp_configure "allow updates", 0 2> go
Turn off single-user mode:
1> sp_dboption database_name, "single user", false 2> go
1> use database_name 2> go
1> checkpoint 2> go
