Altering Databases and Their Options

New databases inherit options from the model database. After you create a database, you can modify these settings at any time by using SQL Server Management Studio, the ALTER DATABASE statement, and other SQL commands. In most SQL Server editions, many standard options can be set to TRUE (ON) or FALSE (OFF) states. Other options accept specific values that specify their configured state, such as GLOBAL or LOCAL.

Setting Database Options in SQL Server Management Studio

To set database options in SQL Server Management Studio, complete the following steps:

  1. In SQL Server Management Studio, use the Registered Servers view to select a type of server, such as Database Engine. If you need to expand a server group to see ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.