DBCC failed SET options have incorrect settings 
Author Message
 DBCC failed SET options have incorrect settings
I read the article in the knowledge base - 301292, but it
doesn't say how to fix the problem when running the checks
through a maintenance plan.

Here's the error:
DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER'.  

Please help!



Tue, 15 Nov 2005 20:09:38 GMT
 DBCC failed SET options have incorrect settings

How can I set the quoted_identifier option on, for each
database before running the maintenance plan?
Lisa
Quote:
>-----Original Message-----
>I read the article in the knowledge base - 301292, but it
>doesn't say how to fix the problem when running the
checks
>through a maintenance plan.

>Here's the error:
>DBCC failed because the following SET options have
>incorrect settings: 'QUOTED_IDENTIFIER'.  

>Please help!
>.



Tue, 15 Nov 2005 21:08:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Incorrect Set Options issue

2. Msg 1934, incorrect QUOTED_IDENTIFIER setting - why???

3. Setting PDQ Priority >1 returns incorrect number of rows

4. Setting default value of field...having problems

5. INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.

6. UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'.

7. INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS., ARITHABORT'.

8. Having trouble setting up the menu bar print icon

9. Setting SQL Server query processing options via Access/VBA

10. Setting the sql option to allow translation

11. Setting option to prompt SQL for login box

12. Getting a SQL Server option setting


 
Powered by phpBB® Forum Software