Hello there
When i press browse button on the connect option of the query anlyser, I get
list of all available servers on my network.
Is there a way to export this list to source like excel?Try this one here:
master..xp_cmdshell 'OSQL.exe -L'
HTH, Jens Suessmeyer.|||Roy
Dim i As Integer
'Use the SQL DMO Application Object to find the
available SQL Servers
Set oSQLServerDMOApp = New SQLDMO.Application
'Don't show events
gShowServerEvents = False
Dim namX As NameList
Set namX = oSQLServerDMOApp.ListAvailableSQLServers
For i = 1 To namX.Count
txtServer.AddItem namX.Item(i)
Next
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uIYW03SPGHA.2668@.tk2msftngp13.phx.gbl...
> Hello there
> When i press browse button on the connect option of the query anlyser, I
> get list of all available servers on my network.
> Is there a way to export this list to source like excel?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment