none
get list of sql instances RRS feed

  • Question

  •  

    i have a form and i want to get a list of all available sql instances in a combobox?

     

     

    Sunday, January 6, 2008 7:42 PM

Answers

  • This can be done by using an SQLDataSourceEnumerator.
    It returns a data table with all reachable instances of MSSQL 2000 and 2005 on the local network.

    An example is here: Enumerating Instances Of SQL Server.
    The example just prints the reachable instances to console, but you can set the data table returned by the enumerator as the combo's data source.

    Regards
    Sunday, January 6, 2008 8:28 PM