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.