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. Most options can be configured using Microsoft SQL Server Management Studio. Some additional options must be set by using the SET clause of the ALTER DATABASE statement.
To change the option settings for a database
-
In Object Explorer, connect to a Database Engine instance, expand the server, expand Databases, right-click a database, and then click Properties.
-
In the Database Properties dialog box, click Options to access most of the configuration settings. File and filegroup configurations, mirroring and log shipping are on their respective pages.
See Also