|Applies To||RSA Archer|
Microsoft SQL Server version 2008 and 2012
|Issue||While creating a DB job to delete a table, the job fails with the error 1934 shown in the job history. The complete error will be as follows|
DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. [SQLSTATE 42000] (Error 1934). The step failed.
This can happen to any delete script.
Example: delete tblIVCalcErrorData
If we run the same query, instead of the job, it works fine
|Resolution||To fix this, modify the job to contain the following commands:|
SET QUOTED_IDENTIFIER ON
SET QUOTED_IDENTIFIER OFF
|Notes||For more information on QUOTED_IDENTIFIER http://msdn.microsoft.com/en-IN/library/ms174393.aspx|
|Legacy Article ID||a67717|