The Database Configuration view allows you to view the configuration settings of the databases on the selected SQL Server instance. This view contains a single grid that includes the configuration settings for all databases on the selected SQL Server instance.

The columns displayed on the Database Configuration view differ between SQL Server 2005 and SQL Server 2008 instances.

You can use the Database Configuration view to analyze configuration differences between databases or databases with incorrect configuration settings.

If you experience database issues, the Database Configuration view can help you determine if the problem is caused by configuration errors.

Access the Configuration view

To open the Configuration view of the SQL Diagnostic Manager Databases tab, select the appropriate SQL Server instance, click Databases, and select Configuration.

Null values in the Collation and Version columns

If the database is not started and AUTO_CLOSE is set to ON, these columns are set to null until the database is started.



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal