• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Apply sql server 2005 service pack 1 then 2 or just service pack 2?

I currently have SQl server 2005 installed but have no service packs applied.

Do I have to apply sql server 2005 service pack 1 then 2 or does service pack 2 contain service pack 1 anyway?
  • 2
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
Not necessarily, you can apply sp2 directly .
EdAuthor Commented:


but why 'Not necessarily' could there be a situation where you would apply SP1 then SP2?
Aneesh RetnakaranDatabase AdministratorCommented:
ususally, people will apply sp1 first and then sp2.
SP2 has everything in it SP1 does and then some.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now