Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m.rudolph
Starting Member
2 Posts |
 Posted - 2007-09-27 : 10:17:34
|
| Hello all,Is there a preferred method for detecting SQL Server 2005 SP2? I do installation/deployment and during my install script I would prefer to skip the SP2 install if the instance is already upgraded.I had tried to check HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL to first find out what MSSQL.[n] our instance took.After that I was attempting to check HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.[n]\Setup\SP but there have been cases where the key SP did not exist.I decided I could just install it under the condition that no key existed at all, assuming since the 'SP' key did not exist, the instance was not upgraded. In tests however, after a fresh install of SP2, the key was not there.I guess the question is further defined as: does installing SP2 place a flag that it exists anywhere else? Is it supposed to write to HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.[n]\Setup\SP?Thanks,-Mike |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-27 : 10:21:47
|
SELECT @@VERSIONSELECT SERVERPROPERTY('ProductLevel')SELECT SERVERPROPERTY('ProductVersion')
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Kristen
Test
22859 Posts |
|
|
m.rudolph
Starting Member
2 Posts |
Posted - 2007-09-27 : 11:41:33
|
| Thanks folks.I suppose I should find a way to output SELECT SERVERPROPERTY('ProductLevel') and parse it since I can't really execute SQL scripts during the installation. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Detecting Service Pack 2