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...