July 19, 2005 at 2:09 pm
Hi All,
I am having a problem with an optimization maintenance job. I have eight databases which I optimize and rebuild the indexes on once a week. I noticed today the jobs have failed consitantly for two of the databases with the following error:
[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 jobs run just fine on the other six databases. I do not have the 'use quoted identifiers' option set in the properties page so I set the option to use quoted identifiers and tried the jobs again, with the same results; they failed. I removed the two databases from the optimize jobs and the jobs succeded (of course). Has anyone had any experience with this before? and how did you get around this problem? Thanks!
Ken
July 20, 2005 at 6:48 am
This error occurs when your database has indexed views or indexes on computed columns.
http://support.microsoft.com/default.aspx?scid=kb;en-us;301292
July 20, 2005 at 7:31 am
Thank you for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply