SetOptions
The various types of predicate SET options found in SQL.
AnsiDefaults = 1024
ANSI_DEFAULTS
AnsiNullDfltOff = 2048
ANSI_NULL_DFLT_OFF
AnsiNullDfltOn = 4096
ANSI_NULL_DFLT_ON
AnsiNulls = 8192
ANSI_NULLS
AnsiPadding = 16384
ANSI_PADDING
AnsiWarnings = 32768
ANSI_WARNINGS
ArithAbort = 8
ARITHABORT
ArithIgnore = 16
ARITHIGNORE
CONCAT_NULL_YIELDS_NULL
CURSOR_CLOSE_ON_COMMIT
DisableDefCnstChk = 4194304
DISABLE_DEF_CNST_CHK
FmtOnly = 32
FMTONLY
ForcePlan = 65536
FORCEPLAN
ImplicitTransactions = 524288
IMPLICIT_TRANSACTIONS
NoBrowsetable = 16777216
NO_BROWSETABLE
NoCount = 64
NOCOUNT
NoExec = 128
NOEXEC
None = 0
None
NumericRoundAbort = 256
NUMERIC_ROUNDABORT
ParseOnly = 512
PARSEONLY
QuotedIdentifier = 1
QUOTED_IDENTIFIER
RemoteProcTransactions = 1048576
REMOTE_PROC_TRANSACTIONS
ShowPlanAll = 131072
SHOWPLAN_ALL
ShowPlanText = 262144
SHOWPLAN_TEXT
ShowPlanXml = 8388608
SHOWPLAN_XML
XactAbort = 2097152
XACT_ABORT