DBCC USEROPTIONS
Returns the SET options active (set) for the current connection.
Syntax
DBCC USEROPTIONS
Result Sets
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.
Permissions
DBCC USEROPTIONS permissions default to any user.
Examples
This example returns the active SET options for the current connection.
DBCC USEROPTIONS