For a project I am involved in I have written a small VB6 program to extract the data from a SQL Server 7 database and create a SQL script to repopulate the tables with this data after a database structure change required by the client.
It is of course straightforward to get a list of databases on the server, but I need to be able to get a list of servers that the workstation can "see", ie. the list shown in the SQL server group in the SQL Server 7 Enterprise Manager. I am assuming at present that the Windows API must be used for this, and was wondering if anyone could point me in the right direction for the required functions.
TIA
Stuart