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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Patches for SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-02 : 09:10:09
Summer writes "Microsoft's site is confusing as far as what patches should be installed on SQL 2000 and 7.0. Please let me know if this is correct:

If a server is running anything other than sp3 or sp3a, I should apply the sp3a service pack + the cumulative security patch to bring the version up to 8.00.818.

If a server is running SP3, I should apply the cumulative security patch to bring the version up to 8.00.818.

If a server is running SP3a, I should apply the cumulative security patchto bring the version up to 8.00.818.

If a server is running SQL Server 7.0, the final version should be the SP4 patch + the cumulative security patch. I couldn't find anything stating what that version is.

Thanks for your help!"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-02 : 09:34:33
http://www.tacktech.com/display.cfm?ttid=60

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -