Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Sql Server2000 Service Packs Expand / Collapse
Author
Message
Posted Saturday, October 4, 2003 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 5, 2003 12:00 AM
Points: 8, Visits: 1
I just installed SQL Server2000 Developer Edition ("Release A" on the CD). In the box is a CD for SP3a (do I need to do SP3 first?). How do I find out what SP's need to be installed?






Post #16957
Posted Saturday, October 4, 2003 10:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 28, 2004 8:04 AM
Points: 305, Visits: 1
You can install SP3a by itself with no other sp's installed.

HTH

Ray Higdon MCSE, MCDBA, CCNA



------------

Ray Higdon MCSE, MCDBA, CCNA
Post #82146
Posted Saturday, October 4, 2003 11:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 5, 2003 12:00 AM
Points: 8, Visits: 1
I just found out that I have 8.00.194. The documentation says I am shy of SP1, SP2, SP3, SP3a. Should I do any of these?

Thanks for the help.




Post #82147
Posted Saturday, October 4, 2003 12:09 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 28, 2004 8:04 AM
Points: 305, Visits: 1
All SQL Service packs, that I know of are cummulative. Instlling sp3a gives you all the fixes in all prior patches.

HTH

Ray Higdon MCSE, MCDBA, CCNA



------------

Ray Higdon MCSE, MCDBA, CCNA
Post #82148
Posted Sunday, October 5, 2003 1:00 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 22, 2011 5:35 AM
Points: 1,758, Visits: 9
Dek,

Ray is correct. As far as I know the sp's are cumulative. You only need to install sp3a

AJ Ahrens
webmaster@kritter.net




Good Hunting!

AJ Ahrens


webmaster@kritter.net
Post #82149
Posted Sunday, October 5, 2003 2:47 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, October 19, 2014 4:48 AM
Points: 1,327, Visits: 156
Also, don't forget to get any other security and hotfixes after SP3a. Check at http://www.microsoft.com/technet/security/current.asp





Mark
Post #82150
Posted Monday, October 6, 2003 3:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 5, 2003 12:00 AM
Points: 8, Visits: 1
I installed SP3a, but notice on the MS site that SQL Server 2000 "should have SP's installed for Data Components and for Analysis Services." MY Developer Edition CD came only with the SP3a for "Desktop Engine."

1. do I need the other two SPs?
2. if so, do they need to be installed in any sequence (like, do I need to uninstall the Desktop Engine patch, before I install the three SPs?

Thanks.




Post #82151
Posted Tuesday, October 7, 2003 6:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 2:51 AM
Points: 224, Visits: 137
Data components is the normal service pack, Sql2ksp3.exe that you already installed.

Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you do not know it, you probably won't need it.

It is has its own service pack, Sql2kasp3.exe and you can install it after the data components service pack. I am not sure if it is necessary, just never got the idea to do it first.





Post #82152
Posted Tuesday, October 7, 2003 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 5, 2003 12:00 AM
Points: 8, Visits: 1
quote:

Data components is the normal service pack, Sql2ksp3.exe that you already installed.

Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you do not know it, you probably won't need it.

It is has its own service pack, Sql2kasp3.exe and you can install it after the data components service pack. I am not sure if it is necessary, just never got the idea to do it first.

Sorry that it seems I'm belaboring the point, but as I look at the MS technet site for downloads for SQL Server 2000 http://www.microsoft.com/sql/downloads/2000/sp3.asp, and scroll down to about the middle of the page, it says :

"This service pack includes the following files:

Sql2ksp3.exe. Updates for database components.
Sql2kasp3.exe. Updates for Analysis Services components.
Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).
Note: The service pack files for SP3a have the same names as the files for SP3."

I installed the last one only as it was the only one on my Develop Edition CD.

Am I okay with that, or do I need to get the Sql2ksp3.exe installed also?







Post #82153
Posted Tuesday, October 7, 2003 10:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 3, 2011 8:03 AM
Points: 1, Visits: 12
I was wondering if anyone knew if the S2K cumulative patch is the same as the latest S2K hotfix? And if there is any word on when S2K sp4 (assuming it will include sp3a and the cumulative patch) will be available?

Thanks!




Post #82154
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse