Detect SQL 2005 Instances Only

[stevep]

I have reviewed the MS SQL Server Connection Sample file and it works great. The only problem is I only want to return SQL Server 2005 Instanances and ignor all the SQL Server 2000 Instanances.

Is there any way to do this?

[neillans]

Hi Steve,

I believe not - the list we are fetching lists both, and I can't see any way that we can filter them without connecting to each server - sorry

[RobertKozak]

Any way that you can add an option to filter by Instance Name? SQL 2005 Express has a default instance of SQLEXPRESS.

-- Robert

[MichaelNesmith]

You could do such filtering in MSIcode script using the string manipulation MSIcode commands (check under the Scripting category on the MSIcode palette).

[RobertKozak]

I do that already but it has a few drawbacks compared to this request:

1. Its slower. The MSICode is much slower than the code you would use to iterate and filter out specific instances.

2. Messier. You have to write more code that can distract from the intent of what you are trying to do. Also chance of introducing bugs.

3. It will give you guys a chance to fix the bugs that are already in the "Detect MS SQL Instances". For example on Windows 2003 it only returns the machine name if its MSDE OR SQL 2005, OR SQL 2005 Express etc. You can't determine which version is installed on a target machine.

Robert