Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.