Jump to content

Does SQL Server 2005 SP2 Contains SP1 updates ?

- - - - -

  • Please log in to reply
3 replies to this topic

#1
rakz

rakz

    Newbie

  • Members
  • PipPip
  • 17 posts
Does SQL Server 2005 SP2 Contains SP1 updates too or only the SP2 updates.
same is the query for SQL 2000. Does SQL 2000 SP4 contains SP 1,2,3 & 3a ?

#2
Alexander

Alexander

    It's Science!

  • Moderators
  • 4,118 posts
  • Location:Vancouver, Eh! Cleverness: 200
Yes, it should contain the updates and fixes for all the previous updates, although it may drop some support for specific things such as in older SP1's. You may wish to look at the change logs for each service pack to ensure they support what you need, and know what features were dropped or not.
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.

#3
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,298 posts
  • Location:Karlstad, Sweden
  • Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
  • Learning:Java, C#
Very often, if a service pack (SP) does not contain older SPs, microsoft tend to require older SPs to be installed before, so if it don't require it, it usually contains all older as well. (with nullw0rms exception that if some functionality was dropped, but that's usually no big deal)
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall

#4
rakz

rakz

    Newbie

  • Members
  • PipPip
  • 17 posts
ok Thank you both for helping me...i was really breaking my head...




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users