Do not run sp_fixindex on the clustered index of the sysobjects or sysindexes tables. If you do, sp_fixindex will return this error message:
The index with id 1 on sysobjects cannot be recreated.
Do not run sp_fixindex on user tables.
You can run sp_fixindex on
a nonclustered index on sysobjects, but you
will encounter a known problem. For a workaround, refer to “Workaround for sysobjects Nonclustered Indexes”.
Sybase would like to pursue the source of any persistent index corruption that is not hardware related. This debugging process requires that you do two things:
Leave your system catalogs untouched. Sybase must dial in to your database and examine the corruption prior to any modifications to the system catalogs.
Preserve your transaction logs. Sybase must examine your transaction logs to find the source of modifications to the pages involved.
