September 18, 2002 at 6:53 am
I am seeing the below error message from a Maintenance Plan History screen. I have not touched the below setting and it is currently turned off. How to I fix this so my DBCC check will work?
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
September 19, 2002 at 6:26 am
anyone???
September 19, 2002 at 7:30 pm
Try turnning it On, maybe someone change it without your advice. Re run the maintenance plan and see what happens.
If you run your DBCC manually, shows the same error. Are you running DBCC CheckDB?
September 23, 2002 at 7:56 am
the database is clean with a manual DBCC CheckDB.
BUT, the maintenance plan will not run due to the above error.
???
September 23, 2002 at 7:58 am
ya I tried it ON and OFF. Still the same error.
???
October 2, 2002 at 8:56 am
HELP!!!!!!!!!!!!!!
October 2, 2002 at 9:10 am
According to this KB article, you'll have to run the DBCC command outside of the maintenance plan as a T-SQL job step.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q301292
It's a problem with all SQL 2K versions. It probably works when you run the DBCC manually because your client (QA for instance) sets the appropriate options by default.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
October 2, 2002 at 9:16 am
but it worked for months and just stopped working.
October 2, 2002 at 9:35 am
The last time this question came up in the forums, that was the case as well.
You might check the database properties and see if someone changed the setting for Use quoted identifier.
If you are using Enterprise Mananger, Expand the server, Expand databases, right click on the database and choose properties. Choose the options tab. You should find it there.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply