Error 601 - corrupt database??

[Fin]

I am getting an error every so often on my databases,
I get the following error,
DEscriptor for system table 8 in database not found in hash table,
the databses are unusalble until I stop SQL & shut down

I checked the books on line and it says to stop SQL and shut down,
I have done this and it solves the problem temporaily,

Is there any way that I can permanently fix this,

If anyobne has any ideas I'd appreciate it,
Thanks,
Fin

[MAK/AnanthaKumar Muthusamy]

I believe u should run
dbcc checkalloc
dbcc checkdb for that database.

depending upon the number of transaction database
maintenance should be done.!!!


Good Luck.
MAK





------------
Fin at 9/10/99 5:52:52 AM

I am getting an error every so often on my databases,
I get the following error,
DEscriptor for system table 8 in database not found in hash table,
the databses are unusalble until I stop SQL & shut down

I checked the books on line and it says to stop SQL and shut down,
I have done this and it solves the problem temporaily,

Is there any way that I can permanently fix this,

If anyobne has any ideas I'd appreciate it,
Thanks,
Fin