Viewing a Database
You can view the definition of a database and its configuration settings when you are troubleshooting or considering making changes to a database.
To view a database
Transact-SQL
Enterprise Manager
SQL-DMO
To view the settings for a database
Transact-SQL
Enterprise Manager
SQL-DMO
To view a list of databases on a server
Transact-SQL
Enterprise Manager