integrity check failed

on sql server 2000, try to do integrity check on several database once a week
but failed, what would be main area to look up? thank you
Drop and recreate your indexes then update statistics
I have a script somewhere that can automate the process
Do this during low usage times, as it willl greatly affect performance
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:2EFA3260-8995-4985-BB70-9D770878A9EB@.microsoft.com...
> on sql server 2000, try to do integrity check on several database once a
> week
> but failed, what would be main area to look up? thank you
|||no error found on the appliation event viewer and no error found on the sql
server error log. How would i get the script? thank you
"Randy Pitkin" wrote:

> Drop and recreate your indexes then update statistics
> I have a script somewhere that can automate the process
> Do this during low usage times, as it willl greatly affect performance
> "tulip" <tulip@.discussions.microsoft.com> wrote in message
> news:2EFA3260-8995-4985-BB70-9D770878A9EB@.microsoft.com...
>
>