0 out of 1 rated this helpful - Rate this topic

DBCC USEROPTIONS (Transact-SQL)

SQL Server 2005

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

Topic link icon Transact-SQL Syntax Conventions


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

Permissions

Requires membership in the public role.

Examples

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

DBCC USEROPTIONS;

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

DBCC USEROPTIONS (Transact-SQL)

Reference

Other Resources

Help and Information

Community Additions