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 youDrop 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...
> > 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
>
>|||Read the error messages that the DBCC CHECKDB command produced.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"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