Error rebuilding indexes via Database Maintainence Plan in SQL 2000
Posted on 2002-04-24
In SQL 2000 I get the following error when the Database Maintainence Plan rebuilds indexes on a particular database.
[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'.
The maintainence plan was built using the maintainence plan wizard. Rebuilding indexes is just one of the steps in the plan. All other steps pass except for the rebuild indexes step.
I've tried setting Quoted_Identifier to OFF at both the server level as well as the database level with no success. I also know that sqlmaint.exe is what is called by the maintainence plan and sqlmaint connects to the SQL Server using an ODBC connection and logs in using the same account information as the SQL Server Service. I've edited the Windows System DSN ODBC Data Source called "Local Server" and set Quoted_Identifier to OFF there as well, but again with no success.
I'm not sure if this is relevant but, there are tables with calculated members in this database.
I also get the same error when I update statistics on the same database through the maintainence plan. However, if I run sp_updatestats from Query Analyser, the sp executes just fine.
I've gone around in circles on this one. Any help would be greatly appreciated.