DBCC USEROPTIONS in Microsoft SQL Server

DBCC USEROPTIONS

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

Syntax

DBCC USEROPTIONS

Result Sets
DBCC USEROPTIONS returns this result set (values and entries may vary):
Set Option                   Value
—————————- ——————————————-
textsize                     64512
language                     us_english
dateformat                   mdy
datefirst                   7
ansi_null_dflt_on            SET
ansi_warnings                SET
ansi_padding                 SET
ansi_nulls                   SET
concat_null_yields_null      SET
(9 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC USEROPTIONS returns a column for the name of the SET option and a column for the setting of the option.

Permissions
DBCC USEROPTIONS permissions default to any user.

Examples
This example returns the active SET options for the current connection.
DBCC USEROPTIONS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.