DB Maintenance Plan failure

Good morning all...
SQL Server 2000, SP3 running on a W2K Server Cluster.
All other DB Maint Plans run fine (12 DBs). But on one,
we get the following error:
"[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
failed because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER'
I've searched and read everything I can find, but nothing
seems to be "our" problem. Suggestions ranged from
priviledge accounts to "are you running SP3".
Anyone seen this and/or have suggestions?
Thanks,
TonyGood afternoon Tony,
This error can occur if you have indexed views in your database, and you
have the "Reorganize indexes and data pages"check box checked in your
maintenance plan. Indexed views require a number of options to be set in a
certain way when they are build or reindexed, and you have to make sure that
the login under which the maintenance plan is running has them set
correctly. The two options most likely to be set wrongly are
QUOTED_IDENTIFIER and ARITH_ABORT, which should both be ON.
--
Jacco Schalkwijk
SQL Server MVP
"Tony Bowman" <anonymous@.discussions.microsoft.com> wrote in message
news:e72901c3f0b9$664ca1a0$a001280a@.phx.gbl...
> Good morning all...
> SQL Server 2000, SP3 running on a W2K Server Cluster.
> All other DB Maint Plans run fine (12 DBs). But on one,
> we get the following error:
> "[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
> failed because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER'
> I've searched and read everything I can find, but nothing
> seems to be "our" problem. Suggestions ranged from
> priviledge accounts to "are you running SP3".
> Anyone seen this and/or have suggestions?
> Thanks,
> Tony|||Unless they fixed something I don't think this is something you can adjust.
I believe the only way around it is to create your own scheduled job that
does the reorgs and don't use the MP.
--
Andrew J. Kelly
SQL Server MVP
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:u0QDhwL8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Good afternoon Tony,
> This error can occur if you have indexed views in your database, and you
> have the "Reorganize indexes and data pages"check box checked in your
> maintenance plan. Indexed views require a number of options to be set in a
> certain way when they are build or reindexed, and you have to make sure
that
> the login under which the maintenance plan is running has them set
> correctly. The two options most likely to be set wrongly are
> QUOTED_IDENTIFIER and ARITH_ABORT, which should both be ON.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Tony Bowman" <anonymous@.discussions.microsoft.com> wrote in message
> news:e72901c3f0b9$664ca1a0$a001280a@.phx.gbl...
> > Good morning all...
> > SQL Server 2000, SP3 running on a W2K Server Cluster.
> > All other DB Maint Plans run fine (12 DBs). But on one,
> > we get the following error:
> > "[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
> > failed because the following SET options have incorrect
> > settings: 'QUOTED_IDENTIFIER'
> >
> > I've searched and read everything I can find, but nothing
> > seems to be "our" problem. Suggestions ranged from
> > priviledge accounts to "are you running SP3".
> >
> > Anyone seen this and/or have suggestions?
> >
> > Thanks,
> > Tony
>