Can anybody point me in the direction of how to enumerate the SQL Server server groups and then the databases in each server group and then the tables within each database for SQL sever groups visible to my computer?
I have a request for an application that will be used to create the tables required for another application using Oracle, SQL server or Access. Oracle and Access I can do but for the life of me I can't enumerate these SQL Server collections.
There is a ServerGroups collection of the SQLDOM.Application object but the help says it enumerates a list held in the registry. I wrote a test application and every time I run the program the ServerGroups.Count property comes back as zero. I can see our Server Groups in the Enterprise Manager so they do exist.
We are using SQL Server 2000.