Obtaining a List of Databases

R

Robert E. Flaherty

I can use the SqlDataSourceEnumerator to get a list of SQL Server instances.
How do I obtain a list of databases in a given SQL Server instance?
 
C

Cowboy \(Gregory A. Beamer\)

I have always used SQL DMO for enumerating both. You can also call
sp_databases on the master database for each server, but you will have to
have rights to call it.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Data/Log Folder for a SQL Instance? 2
HOWTO: List SQL Servers on Local Machine 8
How to find the databases on a server 6
Iterating my Database Servers 1
SQL and ODBC operate diffrently with Trusted Connection? 3
Figuring sql server version via code 3
about creating a database from Visual Studio 5
creating database and database tables programmatically(SQL-Server2 1

Top