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 the Registered Servers view to select a type of server, such as Database Engine. If you need to expand a server group to see ...