December 17, 2006 at 11:50 am
December 17, 2006 at 1:32 pm
You can create the index on system tables but can't be drop index and you can't run DBCC DBREINDEX against system tables too..
What table is system table index got corrupted?
You can try to use undocumented procedure sp_fixindex procedue to repair system indexes...
Microsoft SQL Server MVP
December 17, 2006 at 2:00 pm
December 17, 2006 at 9:55 pm
Did you check system log for any disk errors?
If there is no HW issue, may be option will be calling PSS...
December 17, 2006 at 10:43 pm
No disk error!...
December 22, 2006 at 10:48 am
Best option will in this case create newdb and copy the data and rename the db...
Try applying latest service pack to see what happens after it...
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply