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?


1 Answer 1


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.

  • 1
    +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. Commented Apr 10, 2014 at 1:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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