Return a Servers Database list

[MTSkull]

I need to be able to get a list of a servers available databases.

 

Each project has its own database with an employee list, and there are 5 different servers each with 5-10 relevant DB's Per server. I would like a list of the Databases to populate a combo box when the user selects a particular server. How do I get the DB list, hopefully using the SQLClient object with MSSQL Server 2K?

 

Thanks

MTS

[PlausiblyDamp]

Try

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

[MTSkull]

Worked like a charm, thanks!