Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sreedevi2901
Starting Member
1 Post |
 Posted - 2011-06-20 : 07:20:11
|
| Hi all,I have job which is scheduled to run everyday at some specified time. I have a SP and couple of T-SQL statements which are executed as part of the job. The SP and the T-SQL Statements execute perfectly in the SQL Management Studio. But when i start the job, the execution fails. The error message i am getting is: UPDATE 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 query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934). The step failed.I have set QUOTED_IDENTIFIER ON inside the SP also. Even then the job execution is failing.Please help me as this is an urgent issue.Thanks in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-20 : 08:12:25
|
Not sure but I think you have to set QUOTED_IDENTIFIER ON before CREATING the SP.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-20 : 11:11:20
|
| Fred is correct. Also:ANSI_NULLSANSI_PADDINGANSI_WARNINGSARITHABORTCONCAT_NULL_YIELDS_NULLMust all be ON and NUMERIC_ROUNDABORT must be OFFSee here |
|
|
|
|
|
|
SQL Job Execution error