---
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: "language-reference"
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"
---
# DBCC USEROPTIONS (Transact-SQL)

[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]

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

:::image type="icon" source="../../database-engine/configure-windows/media/topic-link.gif" border="false"::: [Transact-SQL syntax conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)

## Syntax

```syntaxsql
DBCC USEROPTIONS
[ WITH NO_INFOMSGS ]
```

[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]

## 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):

```output
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.

```sql
DBCC USEROPTIONS;
```

## See also

- [DBCC (Transact-SQL)](../../t-sql/database-console-commands/dbcc-transact-sql.md)
- [SET Statements (Transact-SQL)](../../t-sql/statements/set-statements-transact-sql.md)
- [SET TRANSACTION ISOLATION LEVEL (Transact-SQL)](../../t-sql/statements/set-transaction-isolation-level-transact-sql.md)