How to convert system stored procedures to SET QUOTED_IDENTIFIER ON

[Greg Doherty]

I have created a database to be ansi compliant because I have filtered indexes and calculated columns in my tables, therefore I always have SET ANSI_NULLS ON and SET QUOTED_IDENTIFI ER ON.

I have notice that some system stored procedures have SET QUOTED_IDENTIFI ER OFF and therefore will not work with my tables

eg. [sys].[sp_MSforeachtab le] has SET QUOTED_IDENTIFI ER OFF

Is there any setting that can change this when creating a new database or working with an existing one, or is it necessary to manually modify all scripts with this setting?

Thanks,
Greg

[ck9663]

I'm not sure it's possible, I think it's one of those undocumented stored proc. If you can post your code we might be able to find a workaround it.

Good Luck!!!

~~ CK