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
 
Back
Top