[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL integrity check failing with incorrect settings: 'QUOTED_IDENTIFIER'?

Posted on 2007-07-27
3
Medium Priority
?
970 Views
Last Modified: 2008-01-09
SQL Maintenance Problem, the integrity check and optimization are failing every time on certain databases,
The server is 2003 with sql 2000 SP4

Ive look at the log but to be honest dont know where to start, heres the log of the integrity check


Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SQLSERVER' as 'CURRIC\SQLSRV' (trusted)
Starting maintenance plan 'CD DB Maintenance Plan 3' on 27/07/2007 09:27:13
[1] Database CSdestaffordDB: Check Data and Index Linkage...
[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'.

    The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
    ** Execution Time: 0 hrs, 0 mins, 1 secs **

[2] Database TheColla1_SERV: Check Data and Index Linkage...
[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'.

    The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
    ** Execution Time: 0 hrs, 0 mins, 1 secs **

End of maintenance plan 'CD DB Maintenance Plan 3' on 27/07/2007 09:27:14
SQLMAINT.EXE Process Exit Code: 1 (Failed)
0
Comment
Question by:David
  • 2
3 Comments
 

Author Comment

by:David
ID: 19581061
May i add its for our sharepoint and ms class server dataabases, ive also seen a similar question asked

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21543046.html?sfQueryTermInfo=1+becaus+dbcc+fail+follow+have+incorrect+option+set

and maddog mentions says ""We ended up removing the checks from the backup job and running the integrity checks with a second job using transact sql.

in transact sql (unlike in the job/maintenance settings) you can set the different options.
just use : "set quoted_identifier off" (without quotes) in transact SQL before running "dbcc checkdb".""


But im not sure how to do this?
0
 
LVL 7

Accepted Solution

by:
Hemantgiri S. Goswami earned 750 total points
ID: 19581092
Hi,

Please refer http://support.microsoft.com/kb/902388

HTH

Hemantgiri S. Goswami
MS SQL Server MVP
0
 

Author Comment

by:David
ID: 20537016
I found on the web a small application that shrinks the transaction logs this also helped me
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question