Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 get all the databases present in the sql server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-14 : 09:24:56
writes "dear sql team,
i want to know how can we retrieve names of all the databases present in the sql server into an application.

Kindly help

thanking you

yours faithfully ,
aparna v. kamath
(aparnavkamath@hotmail.com)"

izaltsman
A custom title

1139 Posts

Posted - 2002-03-14 : 09:32:20
Run sp_helpdb with no parameters



Edited by - izaltsman on 03/14/2002 09:32:32
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-03-14 : 20:55:42
How about SELECT * FROM Master..sysdatabases ?

------------------------
GENERAL-ly speaking...
Go to Top of Page
   

- Advertisement -