During my setup I need to identify if the SQL/MSDE 2000 is already installed, and which version/servicepack is installed.
Does anybody know how can I do that?
Thank you very much,
Ajawl
This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
Searching for SQL/MSDE 2000
Started by
Ajawl
, Apr 02 2002 13:29
1 reply to this topic
Murali
-
- Members
- 18 posts
Posted 04 April 2002 - 08:13
I have the following values in the
AppSearch table and RegLocator table
AppSearch Table:
Property : SQLSERVER
Signature : SQLServerVersion
RegLocator Table:
Signature : SQLServerVersion
Root : 2
Key : Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
Name : CurrentVersion
Type : 2
Then in some Custom Action
You can check the value for the property SQLSERVER and it will be something like 8.00.194.
Parse this and get the major version. If the major version is greater than or
equal to 8 then it is SQL 2000 or above.
I don't know how to find the Service pack info.
AppSearch table and RegLocator table
AppSearch Table:
Property : SQLSERVER
Signature : SQLServerVersion
RegLocator Table:
Signature : SQLServerVersion
Root : 2
Key : Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
Name : CurrentVersion
Type : 2
Then in some Custom Action
You can check the value for the property SQLSERVER and it will be something like 8.00.194.
Parse this and get the major version. If the major version is greater than or
equal to 8 then it is SQL 2000 or above.
I don't know how to find the Service pack info.
[b]Murali[b]