Hi,
I've read the readme for the Service Pack 1 for Microsoft SQL Server 2005.
http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQL2005SP1.htm
But I'm not quite clear on what will happen if you currently have SQL Server Express 2005 installed with User Instances, and then you launch the installer for SP1.
Will it also update the User Instance? If so, how could I tell? When I go to the registry for the User Instance it has the older version value ie.
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\[instance name]\MSSQLServer\CurrentVersion = 9.00.1399.06
Shouldn't it be saying 9.00.2047.00?
Does this mean that I have to uninstall the User Instance before installing SP1?
Any help will be appreciated.
Thanks
Sam
User instances work by cloning the actual instance at startup time, so as long as the main instance is updated then all should work.|||User Instances are upgrade automatically as Euan says. You really shouldn't be using the registry to judge the success of an upgrade, it's complex and undocumented. You're not looking at the main Key for the SQL version installed.
Rather, after you perform the upgrade, go into the query tool of choice (Managment Studio, SQLCmd, etc.) and run the following:
SELECT @.@.version
This will return the Edition and Version of the server you connected to. If it is not 2047, then you didn't upgrade that Instance.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
Hi Euan and Mike,
Your comments have been helpful.
What I found was that I actually hadn't upgraded our instance of SQL properly.
I've been using the command line for the SQL installer and worked out that the way for it to update the existing instance (and subsequent user instances) was to use
SQLEXPR.EXE /qb INSTANCENAME=<MyInstance> UPGRADE=SQL_Engine
Using these options for the installer I could confirm the upgrade both in the registry and more importantly using
SELECT @.@.version
Thanks
Sam
No comments:
Post a Comment