Database options control:
The behavior of transactions
Defaults for table columns
Restrictions to user access
Performance of recovery and bcp operations
Log behavior
The System Administrator and the Database Owner can use database options to configure the settings for an entire database. Database options differ from sp_configure parameters, which affect the entire server, and set options, which affect only the current session or stored procedure.
