>Anyone seen that video I received last week from a regular member here? You know, the guy who pick a fight against his computer. :)
>
>Well, I think I know how he felt, because today, nothing is working.
>
>From server crash, to hardware failure, to software reinstall and now to SQL Server corruption I think someone can give a call to Murphy and have him out of our office asap.
>
>SQL Server reports this:
>
>Could not find row in Sysindexes for dbid '7', object '880006166',index '0'. Run DBCC CHECKTABLE on Sysindexes.
>
>I tried reindexing, checking size, etc. But, I still have this message. Any idea on how to fix it? Thanks.
Did you run DBCC CHECKTABLE against sysindexes like the error message suggested? You should probably run DBCC CHECKDB against the entire database just to be safe. Here's a query script you could use:
****************************************
USE yourdatabasenamehere
GO
/* DBCC CHECKTABLE will check and fix
only the specified table in the database */
DBCC CHECKTABLE(sysindexes)
GO
/* DBCC CHECKDB will check and fix all
tables in the database, including sysindexes */
DBCC CHECKDB
GO
****************************************
Depending on the size of the database, the DBCC CHECKDB can take some time. I have one database that is 2.2GB and the DBCC CHECKDB takes about an hour.
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
