Setting Database Options
In this section, I will concentrate on how to set the various database options, as opposed to how the settings will affect your database. Many of the settings are fairly intuitively named, which helps, and are covered in detail elsewhere in this book. For example, a detailed explanation of the Recovery options can be found in Chapter 16, “Database Backup and Restore.”
The Database Options
SQL Server has five categories of options that can be set to control database behavior. The categories and the associated values are listed in Table 11.1.
|Cursor Options ...