Setting Database Options

Use sp_dboption to change settings, which remain in effect until they are changed, for an entire database.

sp_dboption:

Displays a complete list of the database options when it is used without a parameter
Changes a database option when used with parameters

You can change options only for user databases. You cannot change options for the master database. To change a database option in a user database (or to display a list of the database options), execute sp_dboption while using the master database.

The syntax is:

sp_dboption [dbname, optname, {true | false}]

Note: Changes to model’s database options do not affect tempdb or current user-defined multiple temporary databases when you restart SAP ASE. These changes appear only in databases that you create after you change the model database. Restarting SAP ASE clears objects and data contained in the temporary databases, but does not reset database options.

Database Option Descriptions
All users with access to the master database can execute sp_dboption with no parameters to display a list of the database options.
Viewing the Options on a Database
Use sp_helpdb to determine the options that are set for a particular database. sp_helpdb lists each active option in the “status” column of its output.
Displaying Currently Set Switches with sysoptions
The number column of sysoptions contains the switch ID for currently set switches.