Results 1 to 2 of 2

Thread: SQL Server Service List??

  1. #1

    Thread Starter
    Lively Member benski's Avatar
    Join Date
    Sep 1999
    Location
    UK
    Posts
    126

    Exclamation SQL Server Service List??

    Anybody know how to get a list of available SQL Servers, the same list that the SQL Server Service Manager does?

  2. #2

    Thread Starter
    Lively Member benski's Avatar
    Join Date
    Sep 1999
    Location
    UK
    Posts
    126
    I've found this way, if anybody is interested:

    Code:
       Dim objSQLApp As SQLDMO.Application
       Set objSQLApp = New SQLDMO.Application
       
       Dim iServerEnum As Integer
       For iServerEnum = 1 To objSQLApp.ListAvailableSQLServers.Count
          cboServer.AddItem objSQLApp.ListAvailableSQLServers(iServerEnum)
       Next
    It uses the "Microsoft SQLDMO Object Library" as a reference.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width