Setting database options

You can set several dozen options, or properties, for a database to control certain behavior within that database. Some options must be set to ON or OFF, some must be set to one of a list of possible values, and others are enabled by just specifying their name. By default, all the options that require ON or OFF have an initial value of OFF unless the option was set to ON in the model database. All databases created after an option is changed in model have the same values as model. You can easily change the value of some of these options by using Management Studio. You can use the ALTER DATABASE command to set all of them directly.

The sys.databases catalog view lists the current values of all the options. This view also ...

Get Microsoft SQL Server 2012 Internals 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.