Discover your MS SQL Server version
12 settembre 2014
The version reported by SELECT @@VERSION or SELECT SERVERPROPERTY('ProductVersion') is a build number. The table below maps the build numbers of each release to the corresponding service pack.
| Version | RTM (no SP) | SP1 | SP2 | SP3 | SP4 |
|---|---|---|---|---|---|
| SQL Server 2012 codename Denali |
11.00.2100.60 | ||||
| SQL Server 2008 R2 codename Kilimanjaro |
10.50.1600.1 | 10.50.2500 | 10.50.4000 | ||
| SQL Server 2008 codename Katmai |
10.00.1600.22 | 10.00.2531 | 10.00.4000 | 10.00.5500 | |
| SQL Server 2005 codename Yukon |
9.00.1399.06 | 9.00.2047 | 9.00.3042 | 9.00.4035 | 9.00.5000 |
| SQL Server 2000 codename Shiloh |
8.00.194 | 8.00.384 | 8.00.532 | 8.00.760 | 8.00.2039 |
| SQL Server 7.0 codename Sphinx |
7.00.623 | 7.00.699 | 7.00.842 | 7.00.961 | 7.00.1063 |
Source: SQL Server Builds, which also keeps an up-to-date list of cumulative updates for later versions.