Hi,
I've a question regarding Microsfot Knowledge Base Article 30292, SET option when running DBCC with indexes on computed columns. The problem is that SQL Server Agent doesn't turn quoted identifier and arithabort on; therefore, when running a job created by the wizard, it gives me an error stating 'incorrect quoted identifer settings' when rebuilding index on computed columns. Their example in the article works perfectly on DBCC Checkdb but not on DBREINDEX because the latter command is for single table only. I create a script to try enforcing the quoted identifer before running the DBREINDEX command but it always give me an the same error message. The script runs fine in Query Analyzer but not in a job. I'd like to know if anyone has the same problem and the workaround to rebuild indexes in a job.
Thanks in advance.