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.
| Option Category | Option |
|---|---|
| Auto Options | AUTO_CLOSE {ON|OFF} |
| AUTO_CREATE_STATISTICS {ON|OFF} | |
| AUTO_UPDATE_STATISTICS {ON|OFF} | |
| AUTO_SHRINK {ON|OFF} | |
| Cursor Options ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
