Returns the SET options that are active (set) for the current connection.
DBCC USEROPTIONS
DBCC USEROPTIONS returns this result set (values and entries may vary):
Set Option Value
---------------------------- -------------------------------------------
textsize 64512
language us_english
dateformat mdy
datefirst 7
ansi_null_dflt_on SET
ansi_warnings SET
ansi_padding SET
ansi_nulls SET
concat_null_yields_null SET
(9 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC USEROPTIONS returns a column for the name of the SET option and a column for the setting of the option.
DBCC USEROPTIONS permissions default to any user.
This example returns the active SET options for the current connection.
DBCC USEROPTIONS
| Customizing Transaction Isolation Level | SET TRANSACTION ISOLATION LEVEL |
| SET | DBCC |