SQLServerPedia

Recently we had some issues with stored procedures having quoted identifiers set differently.  We wanted to run a query to get a listing of any other procedures having quoted identifiers set on or off.

With some help from people at work we found two queries using the DMV's.

select

* from sys.sql_modules

where uses_quoted_identifier <> 1

and

Select

name

From sys.all_objects

where ObjectPropertyEx ( Object_ID , 'ExecIsQuotedIdentOn' ) = 0 and type = 'p'