SQL DBCC USEROPTIONS

Overview:

                Returns the SET options active for the current connection or database. By executing the DBCC USEROPTIONS command you get to know, what are all values set for Set Option for the current connection or database.

Code:

                DBCC USEROPTIONS

Result:

textsize	2147483647
language	us_english
dateformat	mdy
datefirst	7
lock_timeout	-1
quoted_identifier	SET
arithabort	SET
ansi_null_dflt_on	SET
ansi_warnings	SET
ansi_padding	SET
ansi_nulls	SET
concat_null_yields_null	SET
isolation level	read committed