Skip to content

dbcc-useroptions-transact-sql.md

Latest commit

 

History

History
90 lines (70 loc) · 2.81 KB

dbcc-useroptions-transact-sql.md

File metadata and controls

90 lines (70 loc) · 2.81 KB
title DBCC USEROPTIONS (Transact-SQL)
description DBCC USEROPTIONS returns the SET options active (set) for the current connection.
author rwestMSFT
ms.author randolphwest
ms.date 12/05/2022
ms.service sql
ms.subservice t-sql
ms.topic reference
ms.custom
ignite-2025
f1_keywords
DBCC USEROPTIONS
DBCC_USEROPTIONS_TSQL
USEROPTIONS_TSQL
USEROPTIONS
helpviewer_keywords
DBCC USEROPTIONS statement
active SET options
SET statement, active SET options
dev_langs
TSQL
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

DBCC USEROPTIONS (Transact-SQL)

[!INCLUDE SQL Server SQL Database Azure SQL Managed Instance FabricSQLDB]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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;

See also