If you just want to see what's installed on the machine you're currently logged in to, I think the most straightforward manual process is to just open the SQL Server Configuration Manager (from the Start menu), which displays all the SQL Services (and only SQL services) on that hardware (running or not). Private static void DisplayData( table)įoreach ( row in table.Rows)įoreach ( col in table.Columns)Ĭonsole.WriteLine("", col.ColumnName, row) Ĭonsole.WriteLine("=")
table = instance.GetDataSources() Ĭonsole.WriteLine("Press any key to continue.") Retrieve the enumerator instance and then the data.
In order to retrieve the table containing information about the available SQL Server instances, you must first retrieve an enumerator, using the shared/static Instance property: using The results displayed are not always complete. This returned table contains a list of server instances available on the network that matches the list provided when a user attempts to create a new connection, and expands the drop-down list containing all the available servers on the Connection Properties dialog box. The SqlDataSourceEnumerator class exposes this information to the application developer, providing a DataTable containing information about all the visible servers. SQL Server permits applications to find SQL Server instances within the current network.
0 kommentar(er)
