asked on

Visual Basic and SQL Server (SQL-DMO)

Looking for a means to access a list of SQL Servers across an entire domain without using the SQL-DMO object.
Attempted the ListAvailableServers method of SQLDMO.Application, there is a known bug that prevents this from working correctly. Preferable if the list could be invoked from VB or VBScript. Was able to enumerate an object from a Client Side script, however this is not exactly what I need.

ASKER CERTIFIED SOLUTION

DrMaltz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nickles

ASKER

Comment accepted as answer

nickles

ASKER

Thanks Doc!! This worked fantastic... I had to tweak a few things to match our environment, but other than that, was a very smooth implementation. There were a few snags in the domain logic that I had to overcome. Unfortunately, I would quickly be escorted from building if I shared some of the changes, in any event they were quite painless.

Thanks again, appreciate the advice.

Cheers,
Nickles

DrMaltz

Glad it worked according to plan. yeah, the domain code is typically tough. I wrote code similar to this for VC++ and I had to first go out and find all the available domains and then I had to query for SQLServers based on the domain name. A little tedious but it worked. If you have any other questions, experts-exchange is also the place. You can also find me on Undernet IRC chat room vb-advanced,visualbasic,vc++, and c++.