Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Change the Configuration Settings for a Database (SQL Server Management Studio)

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

  1. In Object Explorer, connect to a Database Engine instance, expand the server, expand Databases, right-click a database, and then click Properties.

  2. 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft