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

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 FilesMicrosoft SQL ServerMSSQL.11.instanceMSSQLLOGERRORLOG

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

Table of Contents

Share this post
Search blog posts
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.
Modern Workplace consultant and a Microsoft MVP in Windows and Devices for IT.

Infrastructure architect with focus on Windows Client management & security.

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

follow us in feedly
Categories

Follow on SoMe