-
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
-
Are you talking about SQL Servers that you have registered in Enterprise Manager??? Or list of SQL Servers on the LAN???
-
SQL Server 7 servers ?
Sorry, should have said, any on the LAN. BTW, program uses ADO.
Stuart
-
It is possible only in WindowsNT/2000 environment. Check out the Code Snippet I've posted for the similar question.
-
SQL Server 7 servers ?
Thanks for all your help
Stuart