Export (0) Print
Expand All

DBCC USEROPTIONS (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

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;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft