TFS Versions

by Xavier Dilip Kumar 16. December 2013 07:51
TFS Versions    
2005 RTM 8.0.50727.147
  SP1 8.0.50727.762
2008 RTM 9.0.21022.8
  SP1 9.0.30729.1
2010 RTM 10.0.30319.1
  SP1 10.0.40219.1
  CU2 10.0.40219.371
2012 RTM 11.0.50727.1
  Update 1 11.0.51106.1
  Update 2 11.0.60315.1
  Update 3 11.0.60610.1
  Update 4  
2013 RTM 12.0.21005.1


TFS | TFS 2010 | TFS 2012 | TFS 2013

How to determine the version and edition of SQL Server and its components

by Xavier Dilip Kumar 10. December 2013 08:15


Connect to the instance of SQL Server, and then run the following query:

  • Select @@version

An example of the output of this query is as follows:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009

10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express 

Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

  •  SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

For example, the results resemble the following.

10.0.1600.22 RTM Enterprise Edition


SQL Server

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn


Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs


The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Month List