Database Properties (Options Tab)
New Information - SQL Server 2000 SP3.
Use this tab to view or specify the following options.
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.
Specify that only one user can access the database at a time.
Specify that users can retrieve, but not modify, data from the database.
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.
Enable recursive firing of triggers.
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.
Allow cross-database ownership chaining
Enable cross-database ownership chaining for the database. If you select this check box, the database can be the source or target database in cross-database ownership chaining. If this check box is cleared, cross-database ownership chaining is turned of for the database.
The server configuration setting can override this option. If cross-database ownership chaining is on for the instance, it is also on for all databases. To determine if it is on for the instance, go to the Security tab of the SQL Server Properties dialog box. If the Allow cross-database ownership chaining check box is selected, cross-database ownership chaining is on for all databases.
You cannot turn cross-database ownership chaining off for the master and tempdb databases.
For more information about cross-database ownership chaining, see Using Ownership Chains.
Specify that the database is shut down after its resources are freed and all users exit.
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.
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.