Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 305
SQL Server 304
Administration 252
DBA 241
T-SQL 234
#TSQL 232
Development 226
Tips 216
Guidance 148
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds

Dec 31 2012 12:00AM by Nakul Vachhrajani   

I was recently working on a particular loaned-in SQL Server instance and remarked to a friend that the owning team did not keep their instance up-to-date on the latest and greatest of SQL Server patches and updates. Immediately, the friend enquired as to how I came in possession of this information, to which I explained the following:

Fetching the SQL Server product version

Fetching the SQL Server Product Version is quite easy, and can be done in multiple ways. Two of the most used ones are:


This has to be perhaps the most popular method of knowing the SQL Server product version – simple and easy to use. However for me, the query returns a little too much data in the sense that it also returns the processor architecture information, installation date, OS version, etc – something which I did not set out to do.


And the output on one of my test systems is:

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86)
    Oct 19 2012 13:43:21
    Copyright (c) Microsoft Corporation
    Enterprise Evaluation Edition on Windows NT 6.2 <X86> (Build 8400: ) (VM)


This one is my favourite because it is precise and provides just the information that has been requested.

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion

Staying up-to-date with the SQL Server builds released to market by Microsoft

Now that I have the Product Version # for the installed instance of SQL Server, I can look it up in the official SQL Server build lists for the builds that are released to market by Microsoft:

  • KB957826 - Where to find information about the latest SQL Server builds

The KB957826 links to various other KB articles listing the builds that have been released since particular build of SQL Server was released. For example, 11.0.3000.0 is SQL 2012 SP1 whereas a CU has already been released (

Alternatively, if the Microsoft KB article becomes too much information to digest, one can also refer the one on SQLServerCentral (

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Administration, DBA, Tips, Best Practices, Installation

Nakul Vachhrajani
4 · 36% · 11648



  • Hi Nakul Fantastic one.

    The Links which u have shared with us is really useful to beginners as well as experienced ones to refresh their knowledge about product version.

    commented on Jan 2 2013 3:54AM
    Bala Krishna
    84 · 2% · 676
  • @Balakrishna141: I am glad you found the post useful! Do keep the feedback coming.

    commented on Jan 2 2013 10:55AM
    Nakul Vachhrajani
    4 · 36% · 11648

Your Comment

Sign Up or Login to post a comment.

"#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds" rated 5 out of 5 by 6 readers
#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]