Hi,

I'm doing a Web Deployment Project that need to detect if the target machine has SQL Server 2000 (or any 2000 hotfixes) installed. It seems hard to figure out which RegKey is meant for this value through the use of RegEdt32.exe. I couldn't find any solution from google too. Any helps would be appreciated.

Thank you.

Regards,
Antonio

I would not call RegEdt32.exe in my .NET application because that will restrict where you can run your code, and SQL Server seldom comes with hot fixes however it comes with service packs, some appended like 3a.  The service packs are nothing but .sql files in an installer, I usually open and look at most before I install them.  You can even watch Windows use the .sql files usually based on Network, OS version, hardware and other factors.  I have found a simple T-SQL code that you can modify to meet your needs.  Hope this helps.

http://blog.devstone.com/aaron/archive/2006/12/15/2100.aspx

Hi,

Thank you for your feedback. However, I have found the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

In my Search Registry Condition, I will place this under RegKey property and set the Property property to SQLVERSION. Then in my Launch Condition, I will set the Condition property to SQLVERSION >= 8.0.0 AND SQLVERSION < 9.0.0. As long as the user has SQL Server 2000 installed, my app will be running fine.

Thanks again!

Regards,
Antonio
http://blog.360.yahoo.com/antoniooi

antoniooi:

Hi,

Thank you for your feedback. However, I have found the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

In my Search Registry Condition, I will place this under RegKey property and set the Property property to SQLVERSION. Then in my Launch Condition, I will set the Condition property to SQLVERSION >= 8.0.0 AND SQLVERSION < 9.0.0. As long as the user has SQL Server 2000 installed, my app will be running fine.

Thanks again!

Regards,
Antonio
http://blog.360.yahoo.com/antoniooi

I will not try to access any registry key during installation because there is a reason all SQL Server service packs are simple .sql files in an installer.