Setting Database Options

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


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.