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.