| Capability |
Notes |
General Server Information
Name
Product
Product Level (e.g. SP3)
Edition
Host Operating System
Platform
Version
Version Name
Language
Processors
Root Directory
Server Collation
Is Clustered
Use AWE to Allocate Memory
Minimum Server Memory
Maximum Server Memory
Index Creation Memory
Minimum Memory Per Query
Maximum Worker Threads
Default Index Fill Factor
Default Backup Media Retention
Default Data Location
Default Log Location
Boost SQL Server Priority
Allow Triggers to Fire Others
Cursor Threshold
Default Full-Text Language
Default Language
Max Text Replication Size
Scan for Startup Procs
Two Digit Year Cutoff
Network Packet Size
Remote Login Timeout
Cost Threshold for Parallelism
Locks
Max Degree of Parallelism
|
Displays the configuration settings for this SQL Server Instance. |
 |
|
|
Security Settings
Server Authentication
Auditing Level
Enable Server Proxy Account
Proxy Account
Enable C2 Audit Tracing
Cross Database Ownership Chaining
XPCmd Shell
|
Displays the security configuration settings for this SQL Instance. Certain information does not apply to SQL Server 2000. |
 |
|
|
Connection Settings
Maximum Concurrent Connections
Use Query Governor
Query Governor Limit
Allow Remote Connections
Remote Query Timeout
Named Pipes Enabled (SQL 2005 and above)
TCP Enabled (SQL 2005 and above)
|
Displays the connection configuration settings for this SQL Instance. Certain information is not available for SQL Server 2000. |
|
|
|
Database Settings
Description
Collation
Last Database Backup
Last Database Log Backup
Name
Owner
Date Created
ReadOnly
Size
Space Available
Users
Use Full Text Indexing
Collation
Database and Log File name, autogrowth, location
Recovery Model
Compatibility Level
Auto Close
Auto Create Statistics
Auto Shrink
Auto Update Statistics
Auto Update Asynchronously
Close Cursor on Commit Enabled
ANSI NULL Default
ANSI NULLS Enabled
ANSI Padding Enabled
ANSI Warnings Enabled
Arithmetic Abort
Concatenate Null Yields
Cross Database Ownership Chaining
Date Correlation Optimization
Numeric Round Abort
Parameterization
Quoted Identifiers
Recursive Triggers
Trustworthy
Page Verify
Database Read-Only
Database State
Restrict Access
Extended Properties
Database User - Name, Login, Default Schema, Database Roles
Database Creation SQL Script
|
Displays information about each individual database on this SQL Instance. |
|
|
|
Security - Logins
Login Type
Default Database
Login Disabled
Deny Connect
Creation Date
Default Language
|
Displays information about each login configured for this SQL Instance. All SQL Server roles configured on this Instance are listed including membership of each role. |
|
|
|