How to change the configuration settings for a database (Enterprise Manager)

How to Install SQL Server 2000

How To

How to change the configuration settings for a database (Enterprise Manager)

To change the configuration settings for a database

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database to change, and then click Properties.

  3. 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