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:


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 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.


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:


Table of Contents

Share this post
Search blog posts
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 Modern Workplace and Microsoft 365 security.

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

Cloud & Security Specialist, with a passion for all things Cybersecurity

Cloud and infrastructure security specialist with background in networking.

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

Follow on SoMe