Re: xp_sqlmaint -CkDB SET options error

From: Satya SKJ (satyaskj_at_yahoo.co.uk)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 00:07:02 -0700

http://www.winnetmag.com/SQLServer/Article/ArticleID/26605/SQLServer_26605.html for information. 

-- 
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Performance topic.
"Jasper Smith" wrote:
> Do you have any indexes on computed columns or views in this database ?
> 
> -- 
> HTH
> 
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> 
> "Mark" <nospam_mytrash9@bellsouth.net> wrote in message
> news:40f9f3cf.22216054@newsgroups.bellsouth.net...
> > 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