[thelist] Getting SQL Servers

[Stephen C. Deering]

Try sp_linkedservers and sp_databases to start.  fyi, MS recommends not
querying the system tables directly, since "Querying the system tables
directly may not provide accurate information if system tables are changed
in future releases."

Cheers,
Steve
___________________________
Stephen Deering
Web/Database Developer
Veterinary Information Network
www.vin.com

> I'd like my App to be able to:
>
> 1)  Present the user with a list of local and linked SQL servers
>
> and:
>
> 2)  Once a SQL Server is selected, present the user with a list of
available
> Databases on that Server.
>
> Anybody know how to do this?  Can it be done?  Seems like it should be
> possible...
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>