Jobs failing due to "incorrect settings: QUOTED_IDENTIFIER"

Post a Comment

Did you ever noticed after adding a filtered index or a Computed column, jobs/stored procedures that were using these tables suddenly started failing with the following error

Executed as user: XXXXX\XXXXXX. 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.

The work around of this is to add SET QUOTED_IDENTIFIER ON to each job step.

Related Posts

There is no other posts in this category.

Post a Comment

Subscribe Our Newsletter