DBCC USEROPTIONS (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the SET options active (set) for the current connection.

Topic link icon Transact-SQL Syntax Conventions

  
DBCC USEROPTIONS  
[ WITH NO_INFOMSGS ]  

NO_INFOMSGS
Suppresses all informational messages that have severity levels from 0 through 10.

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.

Permissions

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.

Requires membership in the public role.

The following example returns the active SET options for the current connection.

DBCC USEROPTIONS;  

DBCC (Transact-SQL)
SET Statements (Transact-SQL)
SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

Community Additions

ADD
Show: