DBCC USEROPTIONS (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Returns the SET options active (set) for the current connection.
Transact-SQL syntax conventions
Syntax
DBCC USEROPTIONS
[ WITH NO_INFOMSGS ]
Arguments
NO_INFOMSGS
Suppresses all informational messages that have severity levels from 0 through 10.
Result sets
DBCC USEROPTIONS
returns a column for the name of the SET option and a column for the value of the option (values and entries may vary):
Set Option Value`
---------------------------- ---------------------------`
textsize 64512
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
(13 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Remarks
DBCC USEROPTIONS
reports an isolation level of read committed snapshot
when the database option READ_COMMITTED_SNAPSHOT
is set to ON and the transaction isolation level is set to read committed
. The actual isolation level is read committed.
Permissions
Requires membership in the public role.
Examples
The following example returns the active SET options for the current connection.
DBCC USEROPTIONS;