SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Database Creation and Design How-to Topics
Databases How-to Topics
How to: Add Data or Log Files to a Database (SQL Server Management Studio)
How to: Attach a Database (SQL Server Management Studio)
How to: Change the Configuration Settings for a Database (SQL Server Management Studio)
How to: Create a Database (SQL Server Management Studio)
How to: Create User-Defined Data Types (SQL Server Management Studio)
How to: Delete a Database (SQL Server Management Studio)
How to: Delete Data or Log Files from a Database (SQL Server Management Studio)
How to: Detach a Database (SQL Server Management Studio)
How to: Display Data and Log Space Information for a Database (SQL Server Management Studio)
How to: Generate a Script (SQL Server Management Studio)
How to: Increase the Size of a Database (SQL Server Management Studio)
How to: Move a Database Using Detach and Attach (Transact-SQL)
How to: Rename a Database (SQL Server Management Studio)
How to: Set a Database to Single-user Mode (SQL Server Management Studio)
How to: Shrink a Database (SQL Server Management Studio)
How to: Shrink a File (SQL Server Management Studio)
How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)
How to: Upgrade a Database Using Detach and Attach (Transact-SQL)
How to: View a Database (SQL Server Management Studio)
How to: View or Change the Recovery Model of a Database (SQL Server Management Studio)
How to: View a List of Databases on an Instance of SQL Server (SQL Server Management Studio)
How to: View the Dependencies of a Table (SQL Server Management Studio)
How to: View the Settings for a Database (SQL Server Management Studio)
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

How to: View a List of Databases on an Instance of SQL Server (SQL Server Management Studio)

SQL Server 2005

This topic describes how to view of list of databases on an instance of SQL Server 2005 by using Object Explorer in SQL Server Management Studio.

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. To see a list of all databases on the instance, expand Databases.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.