Error during Opt jobs: Quoted_Identifier and ArithAbort?

[Ovatvvon]

Every week our Opt jobs fail with the following message in the log:

[2] Database dbwrc001: Index Rebuild (leaving 10%% free space)...

    Rebuilding indexes for table 't_accelerated_study'
[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, ARITHABORT'.

I'm not sure where those settings are, or how to change them, or if we want to, or what a work-around may be.

Can anyone help?



-Ovatvvon :-Q

 

[Catadmin]

Look them up in BOL (Books Online) under "Set Arithabort" and "Set Quoted_Identifier" for an explanation.

I assume from your error that you're using SQL 2005? If so, you can right-click the DB name and go to Properties -> Options to see if these two items are enabled or disabled.

Optionally, you can use DBCC USEROPTIONS for either SQL Server 2000 or 2005.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"