sql server 2008 - Implementing QUOTED_IDENTIFIER globally -

sql server 2008 - Implementing QUOTED_IDENTIFIER globally -

i've implemented mechanism help of sqldependency alerts me of changes in particular database table.

but breaks existing functionality i'm updating database table on i've implemented sqldependency.

i'm getting next error:

update failed because next set options have wrong settings: 'quoted_identifier'. verify set options right utilize indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or xml info type methods and/or spatial index operations.

this similar "sqldependency-causes-error-in-other-application".

i've found out proc performs update on table has been created quoted_identifier set off , exact cause of issue.

if alter proc "set quoted_identifier on" works perfect. not feasible solution i'll have search procs , need alter them.

what want know there generic way phone call "set quoted_identifier on" everytime before proc executed application's code.

my application asp.net 4 web app , using microsoft enterprise library 5.0 performing database operations. in i'm using next component: microsoft.practices.enterpriselibrary.data.database

any alternate solutions sqldependency welcome.

[edited] there direct way in sql server 2008 straight set quoted_identifier true without altering proc. i'm thinking write script set quoted_identifier objects dependent on table (using sp_depends).

there way if still looking it, admittedly it's not self-documenting.

exec sys.sp_configure n'user options', n'256' go reconfigure override go

this ssms if right-click on database, go properties, connections, , select quoted identifiers list. makes sql server set quoted identifier alternative on incoming connections.

sql-server-2008 enterprise-library sqldependency quoted-identifier