Data Corruption because of index on system table

Question

Post reply

Data Corruption because of index on system table

Amin Sobati

SSC Veteran

Points: 209
More actions
December 17, 2006 at 11:50 am

#193448

Hi,

Is it possible to drop an index that has been created on system table? It seems such indexes cause DBCC CHECKDB to report error.

Thanks in advance,

Amin

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

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...

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1118132,00.html

MohammedU
Microsoft SQL Server MVP

Amin Sobati SSC Veteran Points: 209 More actions · Answer 2

Amin Sobati

SSC Veteran

Points: 209

December 17, 2006 at 2:00 pm

#678559

That was an index on sysobjects table. Sp_fixindex repairs the error but when you create a new object, again dbcc checkdb reports error! You may easily simulate this on a test db.