>>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.
Thanks, I'll try that.