by XDK
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 |
by XDK
10. December 2013 08:15
Solution:
Connect to the instance of SQL Server, and then run the following query:
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
7fcae43b-da32-49b0-b9c7-1448d7e9546c|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: Versions
SQL Server
Subscribe