Online Documentation for SQL Manager for SQL server

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