3

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

Example:

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

4

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:

SELECT @@VERSION

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. – Aaron Bertrand Apr 10 '14 at 1:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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