EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Database Properties


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

 

To open the dialog, right-click the database alias in DB Explorer and select the Database Properties... context menu item, or use the btnDBProperties Properties button on the DB Explorer toolbar.

 

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.

 

menuDatabaseProperties

 

 

Tick Recovery options

Tick ANSI options

Tick SQL options

Tick Automation options

Tick Cursor options

Tick Advanced database options

 

 


See also:

Register Database wizard

Create Database wizard

Database Registration Info