Database Properties (Options Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Database Properties (Options Tab)

Use this tab to view or specify the following options.

Options

Restrict access

Specify that only the users indicated in the following options can access the database.

Members of db_owner, dbcreator, or sysadmin

Specify that only members of db_owner, dbcreator, or sysadmin can access the database.

Single user

Specify that only one user can access the database at a time.

Read only

Specify that users can retrieve, but not modify, data from the database.

Model

Specify the type of recovery model for the database. For more information on recovery models, see Using Recovery Models.

ANSI NULL default

Specify whether database columns are defined as NULL or NOT NULL by default.

Recursive triggers

Enable recursive firing of triggers.

Select into/bulkcopy

Specify that nonlogged operations can be performed. This option is only available if you are viewing the database properties on a Microsoft® SQL Server™ version 7.0 server. This specifies the type of recovery model for the database. For more information on recovery models, see Using Recovery Models.

Truncate log on checkpoint

Specify that the transaction log is truncated when the checkpoint process occurs. This option is only available if you are viewing the database properties on a SQL Server 7.0 server. This specifies the type of recovery model for the database. For more information on recovery models, see Using Recovery Models.

Torn page detection

Specify that incomplete pages can be detected.

Auto close

Specify that the database is shut down after its resources are freed and all users exit.

Auto shrink

Specify that the database files are candidates for automatic periodic shrinking.

Auto create statistics

Specify that any missing statistics needed by a query for optimization are built automatically during optimization.

Auto update statistics

Specify that out-of-date statistics needed by a query for optimization are built automatically during optimization.

Use quoted identifiers

Specify that SQL Server enforce ANSI rules regarding quotation marks. Select this option to specify that double quotation marks be used only for identifiers, such as column and table names. Character strings must be enclosed in single quotation marks.

Level

Specify the database compatibility level.

List this database in the Active Directory

Specify to list this database in the Active Directory. Active Directory is a central component of the Microsoft Windows® 2000 operating system and provides a place to store information about network-based entities, such as applications, files, printers, and people. This option is only available if the database is on a server that has been added to the Active Directory.

See Also

Setting Database Options