Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Forums
Practice Test
Bookstore
Tip of the Day : How to Call GETDATE Function in a User-Defined Function
SQL Server Helper
Home > > Tip of the Day
SQL Server Helper - Tip of the Day

The Object Explorer Details section of SQL Server 2008 Management Studio now displays more property information about the different objects available in SQL Server 2008.  You can easily view these property information simply by expanding the lower part of the Object Explorer Details window.

When the object currently selected in the Object Explorer is the server, the following property information are available:

  •  Number of Databases (including system databases and Report Server databases)
  •  Default Language
  •  Maximum Degree of Parallelism (Max DOP)
  •  Minimum and Maximum Server Memory (MB)
  •  Maximum Worker Threads
  •  Address Windowing Extensions (AWE) Enabled, C2 Audit Mode Enabled, Common Language Runtime (CLR) Enabled, Common Criteria Enabled, Cross DB Ownership Enabled, Database Mail Enabled

When the object currently selected in the Object Explorer is a database, the following property information are available:

  •  Mail Host (True/False)
  •  Mirroring Status
  •  Ownership Chaining
  •  Recovery Model
  •  Primary File Path, Default File Group
  •  Compatibility Level
  •  Read Only (True/False)
  •  Collation, Case Sensitivity
  •  Owner
  •  Creation Date
  •  Database Size (MB), Data and Index Space Used (KB), Space Available (KB)
  •  ANSI NULL Enabled, ANSI Padding Enabled, ANSI Warnings Enabled, Arithabort Enabled, Auto Close Enabled, Auto Create Statistics Enabled, Auto Shrink Enabled, Auto Update Statistics Enabled, Broker Enabled, Full Text Enabled, Mirroring Enabled, Quoted Identifiers, Trustworthy Enabled

When the object currently selected in the Object Explorer is a table, the following property information are available:

  •  File Group
  •  System Object (True/False)
  •  Replicated (True/False)
  •  Schema, Owner
  •  Data and Index Space Used (KB)
  •  Row Count
  •  Creation Date

These property information can also be easily copied by simply right-clicking on the any property information.  You have the option to copy a single property value with or without the property name or copy all property values with or without the corresponding property name.

Back to Tip of the Day List Next Tip