getting list of databases from a server

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

How do you get a list of available databases from a server? I need to let
the users pick from a listing of db's available, so they can interact with
that db's data... thanks!
(This is Microsoft SQL Server 2000)
 
never mind :) forgot about the stored procedur

exec sp_databases

that does this for you
 

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

2008 Express Edition missing Data drivers? 3
Obtaining a List of Databases 1
about creating a database from Visual Studio 5
From ADO.NET 1.1 to SQL 2005 and SQL 2008 1
Binding to dynamic sql 10
Trying to restore a .bak in C# 3
DTS WIZARD alternatives? 0
How to recover SQL server database from corrupt mdf file? 3

Back
Top