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 for user databases only. 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}]
To make an option or options take effect for every new database, change the option in the model database.
