Maintenance Plans

I created a SQL Server Maintenance Plan that performs sql
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.
Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.