Very helpful article. I now have my databases all set for ANSI compliance. The only issue that I have is that the system stored procedures are not ANSI compliant. Is there any configuration setting to make them ANSI, or do I need to modify the ones I use manually?

eg. [sys].[sp_MSforeachtable] has SET QUOTED_IDENTIFIER 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