Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : General : SQLServer

Upgrade MSDE 2000 to MSDE 2000 SP4


Procedure to upgrade MSDE to MSDE SP4 :-

Download the 'SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE' file from the below
link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

Run that exe. The files will be extracted in a folder. In the command
prompt from that extracted folder: type the command as follows:

setup /upgradesp sqlrun /L*v C:\MSDELog.log

It will be upgraded the MSDE to MSDE SP4

Note: Before upgrading you can check as follows whether SP4 is already
updated:

Goto command prompt >> osql -U sa -P Fiduciary
> select serverproperty('productversion') (If it returns as '8.00.2039'
> or above then it is SP4 or type the following command from sql prompt)

> select @@version (If the application date is above May 2005, then it is
> SP4.)


Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB