Tag Archives: “Service Pack”

Cumulative update package 1, Cumulative update package 1, Cumulative update package 1, Cumulative update package 1, Cumulative update package 1, Cumulative update package 1, Cumulative Update package 1, Cumulative update package 10, Cumulative update package 10, Cumulative update package 10, Cumulative update package 10, Cumulative update package 10, Cumulative update package 11, Cumulative update package 11, Cumulative update package 11, Cumulative update package 11, Cumulative update package 12, Cumulative update package 12, Cumulative update package 12, Cumulative update package 12, Cumulative update package 13, Cumulative update package 13, Cumulative update package 13, Cumulative update package 13, Cumulative update package 14, Cumulative update package 17, Cumulative update package 2, Cumulative update package 2, Cumulative Update package 2, Cumulative update package 2, Cumulative update package 2, Cumulative update package 2, Cumulative update package 2, Cumulative update package 2, Cumulative update package 3, Cumulative update package 3, Cumulative update package 3, Cumulative update package 3, Cumulative update package 3, Cumulative update package 3, Cumulative update package 4, Cumulative update package 4, Cumulative update package 4, Cumulative update package 4, Cumulative update package 4, Cumulative update package 5, Cumulative update package 5, Cumulative update package 5, Cumulative update package 5, Cumulative update package 5, Cumulative update package 6, Cumulative update package 6, Cumulative update package 6, Cumulative update package 6, Cumulative update package 6, Cumulative update package 6, Cumulative update package 7, Cumulative update package 7, Cumulative update package 7, Cumulative update package 7, Cumulative update package 7, Cumulative update package 8, Cumulative update package 8, Cumulative update package 8, Cumulative update package 8, Cumulative update package 8, Cumulative update package 8, Cumulative update package 9, Cumulative update package 9, Cumulative update package 9, Cumulative update package 9, Cumulative update package 9, Cumulative update package 9, Cumulative update package 9, RTM, RTM, RTM, RTM, Service Pack 1, Service Pack 1, Service Pack 1, Service Pack 1, Service Pack 1, Service Pack 2, Service Pack 2, Service Pack 2, Service Pack 2, Service Pack 3, Service Pack 3, Service Pack 3, Service Pack 3, Service Pack 3a, Service Pack 4, Service Pack 4, Service Pack 4, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

How to find the version, edition, Service Pack and Cumulative Update Version of Microsoft SQL Server and its associated components

Leave a comment

If you want to find out the version and edition of Microsoft SQL Server then please take a look at Microsoft KB 321185 http://support.microsoft.com/kb/321185

This will show you how to find versions for SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012

SQL Server 2005

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 2 http://support.microsoft.com/kb/937137

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 3 http://support.microsoft.com/kb/960598

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 4 http://support.microsoft.com/kb/2485757

SQL Server 2008

Microsoft SQL Server 2008 Cumulative Updates that have been released since SQL Server 2008 – RTM http://support.microsoft.com/kb/956909

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 1 http://support.microsoft.com/kb/970365

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 2 http://support.microsoft.com/kb/2402659

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 3 http://support.microsoft.com/kb/2629969

SQL Server 2008 R2

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released since SQL Server 2008 R2 – RTM http://support.microsoft.com/kb/981356

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 1 http://support.microsoft.com/kb/2567616

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 2 http://support.microsoft.com/kb/2730301

SQL Server 2012

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – RTM http://support.microsoft.com/kb/2692828

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – Service Pack 1

http://support.microsoft.com/kb/2772858

Command Prompt, Microsoft, SBS 2011, Small Business Server 2011, Windows, Windows 7, Windows Server 2008 R2

Microsoft Windows 7 – Service Pack 1 and Microsoft Windows Server 2008 R2 Service Pack 1 – How to Easily Free Up Some Disk Space

Have you started to notice that C drive is getting a little full or do you just want to have a spring clean, well you may not realise it but when you installed Service Pack 1 onto your lovely Windows 7 machine or Windows 2008 R2 Server that Microsoft very sensibly backed up all the old system file before replacing them with new ones.

Assuming that you have had Service Pack 1 installed for sometime without issue it may be good to know that you might be able to reclaim some disk space by dumping these obsolete system files.

Simply launch an elevated Command Prompt by right clicking “Command Prompt” and selecting “Run as administrator”.  Once you are in a command prompt simply paste in the following:

DISM /online /Cleanup-Image /SpSuperseded

Be patient with this command as it will need to enumerate a large number of files and could take up to 60 minutes to complete.  Once finished I would recommend a reboot.

Windows 7 and Server 2008 R2 all use an imaging environment to install so with this command we are launching Deployment Image Servicing and Management (DISM) and then telling it to remove any of the superseded service pack files.  If you do not have any files to remove, might be because someone else has already removed them or your computer/server may have already come with Service Pack 1 pre-installed/integrated.  In this instance you will get a message like the one below, you will also get this if you try to run the command a second time after all the old files have already been removed.