Hi Sergey,

I remembered the DataExplorer and have found they have code which does what I need (in case anybody needs details the core of the code is in the datamgmt_sql.prg and datamgmt.prg), I guess I now need to understand the code and see how I can apply it in my situation :)

>>Hi,
>>
>>is there a way for me to get a list of available SQL Servers and their corresponding databases so that when my user first runs my application I can prompt them to select the server and database?
>
>Check Re: List of SQL Servers Thread #779753 for different ways to enumerate SQL Servers.
>
>

>- DB list
>SELECT CATALOG_NAME AS DBname FROM INFORMATION_SCHEMA.SCHEMATA
>