:::: MENU ::::

List SET options for current connection through DBCC USEROPTIONS

  • May 21 / 2009
  • 0
DBCC Commands, dbDigger, Monitoring and Analysis

List SET options for current connection through DBCC USEROPTIONS

Often i am required to verify any of batch level options for my current connection. This task may be easily completed through use of informational DBCC command (DBCC USEROPTIONS) in following way

DBCC USEROPTIONS
GO

Options are listed in following format

List of SET options for current connection

Also it is relevant to mention here that options may be of

  • SQL Server instance level
  • SQL Server database level
  • T-SQL batch level
  • T-SQL Statement level

OLEDB applications can control some ANSI options through their connection options. Microsoft recommends not to change SET options through SET statements. Instead using the connection properties of ODBC/OLEDB or system stored procedure sp_configure is preferable.

  • A database level option overrides the instance option
  • Batch level option overrides database option
  • Statement level option overrides batch level options
Consult us to explore the Databases. Contact us