Find all database names in a SQL Server instance

Posted Date: 20 Nov 2008	Resource Type: Articles	Category: Databases
Author: gururajan	Member Level: Gold
Rating:	Points: 10

SQL SERVER 2000:
select name from master..sysdatabases
SQL SERVER 2005:
select name from sys.databases
Note: Many enhancements were made to the database. Query all of the columns in sys.databases to understand the new enhancements like snapshot, etc.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Find all database names .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Find all tables that have columns with an identity property
	Previous Resource: Find all Procedures in a Database
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources