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:
In SQL Server Management Studio, use Registered Servers view to select a type of server, such as Database Engine. If you need to expand a server group to see the ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
