March 11, 2002 at 10:17 am
I found problems in one of my databases running checkdb this weekend. It is reporting an error in my sysdepends system table on index id 0. The clustered index. I have run checkdb repair_rebuild and I still am getting the error. What next?? anyone have any suggestions.
Tom Goltl
March 11, 2002 at 1:09 pm
Which database? If is tempDB then stopping and restarting automatically should fix. If not the stop SQL and delete tempDBs data and log files and restart SQL, it will automatically rebuild tempDB. (I have had this happen to me twice in 2.5 years.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 11, 2002 at 1:50 pm
It's not in tempdb it is in one of my user db's. I figured out what I needed to do though. I found an undocumented sp on the microsoft site: sp_fixindex. It will rebuild a specified index on a system table. It said it was good up to sql7 sp1, but I tested it on my sql2000 machine and it fixed the problem. Only took me 4 hours to find the fix, God forbid microsoft put too much information into BOL.
Thanks for the help.
Tom
March 11, 2002 at 1:58 pm
You might want to post that to the FAQ section as a possible solution since other may come accross this problem and be looking for a way to fix.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply