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:

image

Before updating I only had update 5556 which is CU3:

image

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

Method 1:

Start SQL Server Management Studio

image

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:

image

Before updating the version was 11.0.5556 for CU3:

image

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.

image

And the file before updating to CU4:

 image

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:

image

No comments:

Post a Comment