get a list of local SQL Server 2005

[oyad]

plz, hw can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?

[jmcilhinney]

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

[oyad]

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

thanks sir but an empty dataTable is returned!

[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.

[oyad]

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