SET Options

SET option	Database option	Server option	Default setting
ANSI_DEFAULTS	None	None	n/a
ANSI_NULL_DFLT_OFF ANSI_NULL_DFLT_ON	ANSI null default	user options assigns a default	OFF
ANSI_NULLS	ANSI nulls	user options assigns a default	OFF
ANSI_PADDING	None	user options assigns a default	ON
ANSI_WARNINGS	ANSI warnings	user options assigns a default	OFF
ARITHABORT	None	user options assigns a default	OFF
ARITHIGNORE	None	user options assigns a default	OFF
CONCAT_NULL_YIELDS_NULL	concat null yields null	None	OFF
CONTEXT_INFO	None	None	OFF
CURSOR_CLOSE_ON_COMMIT	cursor close on commit	user options assigns a default	OFF
DATEFIRST	None	None	7
DATEFORMAT	None	None	mdy
DEADLOCK_PRIORITY	None	None	NORMAL
DISABLE_DEF_CNST_CHK	None	user options assigns a default	OFF
FIPS_FLAGGER	None	None	OFF
FMTONLY	None	None	OFF
SET FORCEPLAN	None	None	OFF
IDENTITY_INSERT	None		OFF
IMPLICIT_TRANSACTIONS	None	user options assigns a default	OFF
LANGUAGE	None	None	us_english
LOCK_TIMEOUT	None	None	No limit
NOCOUNT	None	user options assigns a default	OFF
NOEXEC	None	None	OFF
NUMERIC_ROUNDABORT	None	None	OFF
OFFSETS	None	None	OFF
PARSEONLY	None	None	OFF
QUERY_GOVERNOR_COST_LIMIT	None	query governor cost limit	OFF
QUOTED_IDENTIFIER	quoted identifier	user options assigns a default	OFF
REMOTE_PROC_TRANSACTIONS	None	None	OFF
ROWCOUNT	None	None	OFF
SHOWPLAN_ALL	None	None	OFF
SHOWPLAN_TEXT	None	None	OFF
STATISTICS IO	None	None	OFF
STATISTICS PROFILE	None	None	n/a
STATISTICS TIME	None	None	OFF
TEXTSIZE	None	None	OFF
TRANSACTION ISOLATION LEVEL	None	None	n/a
XACT_ABORT	None	None	OFF

)