United States (English)
Sign in
Home
Library
Learn
Samples
Downloads
Support
Community
Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2000
Microsoft SQL Server 2000
How To
SQL Server Enterprise Manager
Creating and Maintaining Databases
Databases
How to create a database (Enterprise Manager)
How to create a database using the Create Database Wizard (Enterprise Manager)
How to increase the size of a database (Enterprise Manager)
How to shrink a database (Enterprise Manager)
How to delete data or log files from a database (Enterprise Manager)
How to change the configuration settings for a database (Enterprise Manager)
How to view a database (Enterprise Manager)
How to view the settings for a database (Enterprise Manager)
How to view a list of databases on a server (Enterprise Manager)
How to display data and log space information for a database (Enterprise Manager)
How to generate a script (Enterprise Manager)
How to start the Database Maintenance Plan Wizard (Enterprise Manager)
How to delete a database (Enterprise Manager)
How to attach and detach a database (Enterprise Manager)
How to create user-defined data types (Enterprise Manager)
How to delete user-defined data types (Enterprise Manager)
How to create a reflexive relationship (Enterprise Manager)
How to create a many-to-many relationship between tables (Enterprise Manager)
How to delete a relationship (Enterprise Manager)
How to create a DEFAULT object (Enterprise Manager)
How to delete a DEFAULT object (Enterprise Manager)
How to view the dependencies of a table (Enterprise Manager)
1 out of 1 rated this helpful
-
Rate this topic
How to view the settings for a database (Enterprise Manager)
SQL Server 2000
How to view the settings for a database (Enterprise Manager)
To view the settings for a database
Expand a server group, and then expand a server.
Expand
Databases
, right-click the database to view, and then click
Properties
.
Click the
Options
tab.
See Also
Viewing a Database
Did you find this helpful?
Yes
No
Not accurate
Not enough depth
Need more code examples
Tell us more...
(
1500
characters remaining)