Resolving a DBCC error when running SQL Maintenance Plan

[craigber]

We have a customer that is attempting to run a SQL Maintenance plan on a weekly basis. However, it always errors on the same table with the message "Error 1934: DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'". The customer has changed the QUOTED_IDENTIFIED setting and still gets the error. MSKB article 301292 discusses this problem when using computed column, but the database does not have computed columns, nor does it have indexed views. Any ideas on what could be causing this?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[mrdenny]

What were the QUOTED_IDENTIFIER settings when the object was created?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[craigber]

Denny,

I assume it was set to the default, but I can't say for sure. This is at a customer site. Changing the value doesn't resolve the issue now.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[mrdenny]

Changing the setting on the SQL Server won't help.

The sqlmaint command has the setting hard coded. If you create an object with the Quoted Identifier set different from the default the sqlmaint can't check the object.

You'd have to remove the object and recreate it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)