Enumerate SQL Servers URGENT????

[CJ Taylor]

Search for SQL DMO

 

[Imran Koradia]

http://www.codeproject.com/useritems/listsqlservers.asp?df=100&forumid=3432&exp=0&select=508182

http://sqldev.net/misc.htm
(see ListSQLSvr, EnumSQLSvr and OleDbEnum)

These are most likely in VB6 ( I haven't checked them out). But the idea is
the same - reference the SQLDMO library and you should be able to simply
copy the code from the samples that use SQLDMO with a few changes here and
there.

hope that helps..
Imran.

 

[Chris Calhoun]

Does anyone know where a working vb.net sample of this functionality may be
found?

Thanks in advance.

 

[Ken Tucker [MVP]]

Hi,

Add a reference to microsoft sqldmo object library in the com
tab.

Dim sqlServers As SQLDMO.NameList

Dim sqlServer As String

' Get a list of servers

sqlServers = New SQLDMO.Application().ListAvailableSQLServers

For Each sqlServer In sqlServers

Debug.WriteLine(sqlServer)

Next



Ken

-----------------------------

Does anyone know where a working vb.net sample of this functionality may be
found?

Thanks in advance.

 

[Chris Calhoun]

Thanks Alot!!!