hi Vilius,
Vilius wrote:
Quote:
Hi,
I have sql server express 2005 installed on my machine.
This version is very first before sp2.
How to upgrade to sp2 - everything I found was full versions like "SQL
Server 2005 Express Edition", "SQL Server 2005 Express Edition with
Advanced Services", but not upgrades ?
How do I do that ? |
to upgrade an existing RTM or SP1 edition of SQLExpress to sp, run the full
SQLExpress ps2 installer (which can install both new instances updated at
sp2 level as upgrade existing insances at that sp level), run the SQLExpress
installation package..
uncheck the "Hide advanced configuration options"..
in the "Instance name" wizard task, select the instance you like to upgrade
(eventually "browse" the installed instances via the <installed instances>
button)..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply