How to List all available Sql Servers in a Domain?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to List all available Sql Servers in a Domain?

  1. #1
    Kishore Guest

    How to List all available Sql Servers in a Domain?


    How to List all available Sql Servers in a Domain?

  2. #2
    Craig Clearman Guest

    Re: How to List all available Sql Servers in a Domain?

    >How to List all available Sql Servers in a Domain?

    Use SQL DMO. Here's some VB code.

    Private Sub Form_Load()

    Dim o As SQLDMO.Application
    Dim s As SQLDMO.Names
    Dim i As Long

    Set o = New SQLDMO.Application
    Set s = o.ListAvailableSQLServers()
    If s.Count Then
    For i = 1 To s.Count
    Debug.Print s.Item(i)
    Next i
    End If

    End Sub

    Ciao, Craig


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center