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]]

* "Craig G" <Ga*******@hotm ail.com> scripsit:

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/netserverenumve r.htm>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[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/groups?thre...TNGP11.phx.gbl

--
Best Regards
Yanick Lefebvre
"Herfried K. Wagner [MVP]" <hi************ ***@gmx.at> a écrit dans le
message de news:2l******** ****@uni-berlin.de...

* "Craig G" <Ga*******@hotm ail.com> scripsit:

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/netserverenumve r.htm>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[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

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/netserverenumve r.htm>

[Herfried K. Wagner [MVP]]

* "Cor Ligthert" <no**********@p lanet.nl> scripsit:

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...

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[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.Applicat ion().ListAvail ableSQLServers

For Each sqlServer In sqlServers

Debug.WriteLine (sqlServer)

Next

Ken

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

"Craig G" <Ga*******@hotm ail.com> wrote in message
news:uE******** ******@TK2MSFTN GP09.phx.gbl...

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