get a list of local SQL Server 2005

Printable View

May 5th, 2010, 07:57 AM
oyad

get a list of local SQL Server 2005

plz, hw can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
:wave:
May 5th, 2010, 08:57 AM
jmcilhinney

Re: get a list of local SQL Server 2005

You can call the SqlDataSourceEnumerator.GetDataSources method and the resulting DataTable will have a Version column.
May 5th, 2010, 11:05 AM
oyad

Re: get a list of local SQL Server 2005

Quote:

Originally Posted by jmcilhinney

You can call the SqlDataSourceEnumerator.GetDataSources method and the resulting DataTable will have a Version column.

thanks sir but an empty dataTable is returned!
May 5th, 2010, 07:49 PM
jmcilhinney

Re: get a list of local SQL Server 2005

Then there are no discoverable instances. That doesn't mean that you can access by specifying their name, but you must know the name ahead of time. If you run the SQL Server Browser service then you should find that some or all instances become discoverable.
May 6th, 2010, 01:46 AM
oyad

Re: get a list of local SQL Server 2005

Quote:

Originally Posted by jmcilhinney

Then there are no discoverable instances. That doesn't mean that you can access by specifying their name, but you must know the name ahead of time. If you run the SQL Server Browser service then you should find that some or all instances become discoverable.

then, i think sql server 2005 detection on local machine by WMI should be a good option. http://blogs.msdn.com/sqlexpress/arc...29/682254.aspx. Anyway Guys, thanks so much for your inputs
:wave: