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 set all of them directly by using the ALTER DATABASE command. (You can also use the sp_dboption system stored procedure to set some of the options, but ...

Get Microsoft® SQL Server® 2008 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.