Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to list all the SPs and CUs applied to a SQL Server 2008R2 instance.


How can I get the above list from SQL Server 2008R2 instance?

share|improve this question

Cumulative updates are exactly that, cumulative. CU2 for example contains all of the fixes included in CU1. As such, the only SP or CU that matters is the last one to be applied which you can determine with:


and Google or a reference list of SQL Server versions. SQLServerBuilds is the popular unofficial list, KB321185 is the official list.

I'm not aware of any way to obtain a complete list of all patches that have ever been applied to an instance. It's likely buried in the registry somewhere but I haven't fished for it.

share|improve this answer
+1 - I commented on the original question on SO: Cumulative updates are, well, cumulative. What difference does it make if you installed a service pack, then cumulative update #x, then cumulative update > #x? What matters is what the build # is now. – Aaron Bertrand Apr 10 '14 at 1:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.