Export (0) Print
Expand All
Expand Minimize

Database Properties (Options Tab)

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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.

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.

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

Show:
© 2014 Microsoft