SQL Runs as a Query but not as a step in a job
Posted on 2013-01-21
We have some jobs that run and insert data from one table to another using a view. Something like:
Insert into table1
(column1, column2, column3)
select column1, column2, column3 from DB2.dbo.View1
If I run that code as a query it executes fine. However when I run it as a step in a job I get this error:
"INSERT 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.
When I got the error I searched for it and found many posts that said I should turn "Quoted_Identifier" on when creating the view. I had done that but just to be sure I dropped all the views and re-created them. I still get the same error.