maintenance plan

We have two SQL 2000 servers, one runs on SP2 and another
one runs on SP3, I set up the same maintanence plans on
them and selected 'attemp to repair any minor problems'
but the job 'Integrity Check' failed at 'Check data and
index linkage' due to 'database needs to be in single user
mode' on both user and system databases. Any idea what I
did wrong? OS is Win2K SP3.
Many thanks!You didn't do anything wrong, it needs to be in single user mode to do this
and if there is any connection in the db it can't put it in single user
mode. You should uncheck this anyway. Let it report the errors and then
you decide how and when to fix them.
--
Andrew J. Kelly
SQL Server MVP
"Ray Yan" <remonyan@.hotmail.com> wrote in message
news:61d901c34107$597b1180$7d02280a@.phx.gbl...
> We have two SQL 2000 servers, one runs on SP2 and another
> one runs on SP3, I set up the same maintanence plans on
> them and selected 'attemp to repair any minor problems'
> but the job 'Integrity Check' failed at 'Check data and
> index linkage' due to 'database needs to be in single user
> mode' on both user and system databases. Any idea what I
> did wrong? OS is Win2K SP3.
> Many thanks!