Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

share|improve this question

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:

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.

share|improve this answer
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 at 1:34

Your Answer

 
discard

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.