Use sp_dboption to change settings for an entire database. The options remain in effect until they are changed. 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}]
Changes to model’s database
options do not affect tempdb or current user-defined
multiple temporary databases when you restart Adaptive Server. These
changes appear only in databases that you create after you change
the model database. Restarting Adaptive Server
clears objects and data contained in the temporary databases, but
does not reset database options.
