plz, hw can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
:wave:
Printable View
plz, hw can i retrieve a list of local sql server 2005 instances on a machine with sql servers 2000, 2005 & 2008 installed?
:wave:
You can call the SqlDataSourceEnumerator.GetDataSources method and the resulting DataTable will have a Version column.
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: