SQL Server 2014: How Old is your Build?

The @@Version is a very handy T-SQL function which gives you the Major SQL Server version, the Edition (Standard, Business Intelligence or Enterprise), Build Number (RTM, Service Packs, Cumulative Update Level), Build Release Date and Windows Version.

Let’s run this query along with @@ServerName which gives us the SQL Server Instance Name too.

SELECT @@SERVERNAME as [SQL Server Name],
@@VERSION as [SQL Version]
 
Running this query on my SQL Server brings up the following:



When you expand the SQL Version column, you get the following.

Microsoft SQL Server 2014 - 12.0.2254.0 (X64) Jul 25 2014 18:52:51  Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

where :

Major SQL Server Version = Microsoft SQL Server 2014
Build Number = 12.0.2254.0 (X64)
Build Release Date = Jul 25 2014 18:52:51
Edition = Enterprise Edition (64-bit)
Windows Version = Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
  
Some SQL Server 2014 RTM Branch Builds are as follows (ordered by Release Date):

Build	Short Description	Release Date (mm/dd)
11.00.9120	SQL Server 2014 CTP1	6/25/2013
12.00.1524	SQL Server 2014 CTP2	10/15/2013
12.00.2000	SQL Server 2014 RTM	4/1/2014
12.00.2342	Cumulative Update Package 1	4/21/2014
12.00.2370	Cumulative Update Package 2	6/27/2014
12.00.2381	KB 2977316 Security Update (QFE)	8/12/2014
12.00.2254	KB 2977315 Security Update (GDR)	8/12/2014
12.00.2402	Cumulative Update Package 3	8/18/2014
12.00.2405	KB 2999809 FIX	9/25/2014
12.00.2430	Cumulative Update Package 4	10/21/2014
12.00.2423	KB 3007050 FIX	10/22/2014
12.00.2436	KB 3014867 FIX	11/27/2014
12.00.2456	Cumulative Update Package 5	12/18/2014
12.00.2464	KB 3024815 FIX	1/5/2015
12.00.2472	KB 3032087 FIX	1/28/2015

The one in bold is installed on my PC and using this table with my Build number gives me an idea of how old is my build. There have been about 8 different builds released after I last installed SQL Server 2014 and I should update my latest build for better performance and security.

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook