Repairing the system table index

Repairing a corrupted system table index requires the following steps:

Repairing the system table index with sp_fixindex

Get the object_name, object_ID, and index_ID of the corrupted index. If you only have a page number and you need to find the object_name, see the Adaptive Server Troubleshooting and Error Messages Guide for instructions.
If the corrupted index is on a system table in the master database, put Adaptive Server in single-user mode. See the Adaptive Server Troubleshooting and Error Messages Guide for instructions.
If the corrupted index is on a system table in a user database, put the database in single-user mode and reconfigure to allow updates to system tables:
```
1> use master
2> go
```
```
1> sp_dboption database_name, "single user", true
2> go
```
```
1> sp_configure "allow updates", 1
2> go
```

Issue the sp_fixindex command:

1> use database_name
2> go1> checkpoint
2> go1> sp_fixindex database_name, object_name, index_ID
2> go

You must possess sa_role permissions to run sp_fixindex.

Disallow updates to system tables:

1> use master
2> go1> sp_configure "allow updates", 0
2> go

Turn off single-user mode:

1> sp_dboption database_name, "single user", false
2> go1> use database_name
2> go1> checkpoint
2> go