Finding a list of SQL Servers

[Craig G]

without using SQLDMO

is there another way, i've used the SQLDMO way but have had a few issues
with it.

is there another way?

Cheers,
Craig

 

[Herfried K. Wagner [MVP]]

without using SQLDMO

is there another way, i've used the SQLDMO way but have had a few issues
with it.

is there another way?

P/invoke, a VB6 sample that needs to be translated before using it can
be found here:

<URL:http://vbnet.mvps.org/index.html?code/network/netserverenumver.htm>

 

[Zoury]

here's a translation i've made a couple months ago for VB.NET (there might
be some change that could be done to optimize the process though.. i was
still a very newbie in vb.net back then..) :
http://groups.google.com/[email protected]

 

[Cor Ligthert]

This is in my opinion absolute the limit in a not dotnet.language.vb
newsgroup related answer?

When you had not placed that message yesterday I had of course not sand this
message, however now it seems to me that I must make you attent on this.

I will remember this one when I see such a message as yesterday from you
again.

)))

Cor

 

[Herfried K. Wagner [MVP]]

This is in my opinion absolute the limit in a not dotnet.language.vb
newsgroup related answer?

When you had not placed that message yesterday I had of course not sand this
message, however now it seems to me that I must make you attent on this.

I will remember this one when I see such a message as yesterday from you
again.

Mhm...

 

[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