DBCC USEROPTIONS

SELECT sessionPROPERTY('QUOTED_IDENTIFIER') quotedidentifier

SELECT SESSIONPROPERTY('ANSI_NULLS') ANSI_NULLS