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 |
|
devmathur
Starting Member
3 Posts |
 Posted - 2007-03-16 : 05:12:20
|
| Yesterday after joining this company I saw that on some server all INTEGRITY & OPTIMIZER jobs are failing with following output"Error:[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. "Interesting thing is that no one is bothering about this.I checked but didnt find anything wrong. |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-16 : 07:54:57
|
| Isn't this an issue when you create a job/procedure with one set of server settings and then implement with another set of server settings? Could be that the job was created with QUOTED_IDENTIFIER ON and the server is currently set to OFF.Just a thoughtRaymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
'QUOTED_IDENTIFIER'