How do I return a list of databases on a server?

[hellferret]

How would you return a list of databases on a specified server?

The eventual aim is to get a list of databases on a specified server into a dropdown in Access 2000.

Any ideas?

 

[cdukes]

The sysdatabases table on the master database will return a list of databases on the server

select * from master..sysdatabases

Chris Dukes

 

[foxdev]

You can also execute sp_helpdb Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org