Thanks Sergey,
I'll see if I can get one of those to work. I like the idea of using the Windows API, but I'm not sure how I would call it after defining it like this:
DECLARE INTEGER NetServerEnum IN netapi32;
INTEGER servername, INTEGER level,;
INTEGER @bufptr, INTEGER prefmaxlen,;
INTEGER @entriesread, INTEGER @totalentries,;
INTEGER servertype, INTEGER domain,;
INTEGER resume_handle
>>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
>