Online Documentation for SQL Administrator for SQL Server

Database Editor

The Database Editor dialog allows you to view/edit a number of properties which can be changed to optimize database performance.

To open the dialog, double-click the database alias in any list of databases or right-click it and select the Edit Database... context menu item.

Lists of databases can be found in the following sections:

• Backup
• Check Databases
• Rebuild/Reorganize indexes
• Storage | Databases
• Security

A number of database-level options that determine the characteristics of the database can be set for each database. Only the system administrator, database owner, members of the sysadmin and dbcreator fixed server roles and db_owner fixed database roles can modify these options. These options are unique to each database and do not affect other databases.

The list of Database Editor tabs is displayed on the navigation bar:

• Setting general options
• Managing filegroups
• Editing database options
• Configuring change tracking
• Viewing database properties
• Setting permissions
• Viewing SQL definition