How to change the configuration settings for a database (Enterprise Manager)
To change the configuration settings for a database
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database to change, and then click Properties.
- Click the Options tab, and select or clear the configuration setting(s) to change.
See Also
Nested Triggers
Renaming a Database
Setting Database Options
Shrinking a Database