Finding a list of SQL Servers

  • Thread starter Thread starter Craig G
  • Start date Start date
C

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
 
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
 
* "Cor Ligthert said:
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...
 
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
 
Back
Top