MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter

























































SQL Server 2014 Build List / SQL Server 2014 Build Versions

Read Comments


Introduction

One of the most important job responsibilities of a Database Administrator is to make sure that SQL Servers within the organizations are applied with the latest security patches, cumulative updates and services packs which are released by Microsoft. However, it is always challenging to keep track of all the security patches, cumulative updates released by Microsoft. In this article I have compiled an exhaustive list of all the security patches, cumulative updates and service packs for SQL Server 2014 Build List released by Microsoft.

For information on Cumulative Updates, Security Patches,  and Services Packs of previous SQL Server Versions, follow the links given below:

It is recommend that you to read the article titled "How to Install a SQL Server Service Pack" to know more about the Best Practices to follow before installing a SQL Server Service Pack or a Cummulative Update for SQL Server.

How to Identify SQL Server Version

Database Administrators can determine the version of SQL Server they are running by executing the below query.

Important Notes: If the below query returns edition as (64-bit) then is a 64 bit instance of SQL Server 2014.

SELECT
 	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition
GO

ProductVersion ProductLevel Edition
12.0.2000.8 RTM Enterprise Edition (64-bit)

The Product Version 12.0.2000.8 represents SQL Server 2014 RTM.

SQL Server 2014 Build List

Build KB Description Release Date
12.0.4416.1 KB3067839  Cumulative Update 1 for SQL Server 2014 SP1  June 19, 2015
12.0.4100.1 KB3058865  SQL Server 2014 Service Pack 1 (SP1)   May 4, 2015
12.0.2546.0 KB3067836  Cumulative Update 8 for SQL Server 2014 June 19, 2015
12.0.2495.0 KB3046038  Cumulative Update 7 for SQL Server 2014 April 20, 2015
12.0.2480.0 KB3031047  Cumulative Update 6 for SQL Server 2014 Feb 16, 2015
12.0.2456.0 KB3011055  Cumulative Update 5 for SQL Server 2014 Dec 17, 2014
12.0.2430.0 KB2999197  Cumulative Update 4 for SQL Server 2014 Oct 21, 2014
12.0.2402.0 KB2984923  Cumulative Update 3 for SQL Server 2014 Aug18, 2014
12.0.2370.0 KB2967546  Cumulative Update 2 for SQL Server 2014 June 27, 2014
12.0.2342.0 KB2931693  Cumulative Update 1 for SQL Server 2014 April 21, 2012
12.00.2000    SQL Server 2014 RTM April  1, 2014

Using XP_MSVER System Stored Procedure

You can also execute the xp_msver inbuilt system stored procedure to know more details related to SQL Server which you are currently running within the organization.

Use master
GO
EXEC xp_msver
GO
EXEC XP_MSVER System Stored Procedure Execution Results in SQL Server 2014



Share this Article



Last Updated On: June 19, 2015

Get Free SQL Server Tips