Search This Blog

Tuesday, March 3, 2015

Identify Whether SQL 2012 SP2 Cumulative Update 4 (CU4) has been installed

I often need to know the current version of a SQL 2012 installation to determine if it need an update.

This KB includes a number of ways to do the work How to determine the version and edition of SQL Server and its components

Latest update is Cumulative Update 4 for SQL Server 2012 SP2

Here is an excellent place to find the latest updates for your SQL servers Microsoft SQL Server Version List

So lets se the results after updating to Cumulative Update 4:

You will be able to find CU4 (hotfix 5559) in installed updates together with the SP2 update and previous Cumulative Updates installed:


Before updating I only had update 5556 which is CU3:


Let try some of the other ways to identify current version.

Method 1:

Start SQL Server Management Studio


In the object Explorer window you will se the current version just right of the server name:

After updating the version is 11.0.5569 for CU4:


Before updating the version was 11.0.5556 for CU3:


Method 2:

Look at the first few lines of the Errorlog file for you current instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.11.instance\MSSQL\LOG\ERRORLOG

As you can see, this entry gives all the necessary information about the product, such as version, product level, 64-bit versus 32-bit, the edition of SQL Server, and the OS version on which SQL Server is running.


And the file before updating to CU4:


Method 3:

As the last thing lets try the query (in SQL Server Management Studio)

Select @@version

When you execute the query you will see the same information as in method 2:


No comments:

Post a Comment