xp_sqlmaint -CkDB SET options error

From: Mark (nospam_mytrash9_at_bellsouth.net)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 04:05:41 GMT

When I run xp_sqlmaint '-S "TESTSERVER" -D CB_QI_Test -CkDB' against one of our
databases, it returns a "SET options have incorrect settings" error message. If
I run "DBCC CHECKDB(CB_QI_Test)" against the same database from QA, it completes
without any errors. I can run xp_sqlmaint -CkDB against other databases without
receiving the above error. Anyone have an idea as to how to correct this
problem.

Here's the code and the output:

EXEC xp_sqlmaint '-S "TESTSERVER" -D CB_QI_Test -CkDB'

output

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760

Copyright (C) Microsoft Corporation, 1995 - 1998

NULL
Logged on to SQL Server 'TESTSERVER'

 as 'HOME\DBA' (trusted)

NULL
Starting maintenance of database 'CB_QI_Test' on 7/18/2004 12:00:11 AM

NULL
[1] Database CB_QI_Test: Check Data and Index Linkage...

NULL
[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'.

NULL
NULL
    The following errors were found:

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

NULL
    ** Execution Time: 0 hrs, 0 mins, 1 secs **

NULL
NULL
End of maintenance for database 'CB_QI_Test' on 7/18/2004 12:00:11 AM

NULL
SQLMAINT.EXE Process Exit Code: 1 (Failed)

NULL

(25 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.

Thanks,
Mark

Relevant Pages

  • SET ARITHABORT ON/OFF ????
    ... INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. ... Andy ...
    (microsoft.public.sqlserver.programming)
  • Nightly maintenance failures
    ... Every night i get a failure rebuilding the indexes for a particular ... database giving the error: ... DBCC failed because the following SET options have incorrect settings: ...
    (microsoft.public.sqlserver)