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