Hi All,

I have a scheduled Maintenance Plan that errors with the following
message:

"[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.

It always errors on the same DataBase. The error occurs on this
particular database when trying to "Rebuild Indexes" and "Integrity
Checks"

We are running SQl Server 2000 Standard Edition with SP3 (8.00.813)
under Windows Server 2003.

Can anyone help please.

Thanks,

Garth Joubert
DataBase Administrator

Phone (DDI): 07 574 4864
Facsimile: 07 574 4863
Email: garth.[Email address protected]

TrustPower Limited
Private Bag 12023
Tauranga
New Zealand


MS Sql Server LazyDBA home page