Algumas vezes precisamos saber qual é a versão do SQL Server rodando no ambiente para confrontar problemas de compatibilidade, etc.
Um exemplo que precisamos saber dessa informação, é para o famoso erro ao restaurar um backup no SharePoint: “Your backup is from a different version of Microsoft SharePoint Foundation”.
Outros fatores podem estar envolvidos também, como versão do SharePoint e hotfix’s. Mas aqui vou mostrar como saber a versão do SQL Server.
SOLUÇÃO:
Abra o Management Studio, clique eu New Query e faça a seguinte pesquisa:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Execute e terá um resultado similar ao abaixo:
Ou execute esta outra pesquisa:
SELECT @@VERSION
E para saber qual versão é o que:
| SQL Server 2008 R2 | ||
| 10.5.1753.0 | SQL Server 2008 R2 CU5 | 20 Dec 2010 |
| 10.5.1746.0 | SQL Server 2008 R2 CU4 | 18 Oct 2010 |
| 10.5.1734.0 | SQL Server 2008 R2 CU3 | 17 Aug 2010 |
| 10.5.1720.0 | SQL Server 2008 R2 CU2 | 25 Jun 2010 |
| 10.5.1702.0 | SQL Server 2008 R2 CU1 | 18 May 2010 |
| 10.5.1660.1 | SQL Server 2008 R2 RTM | 12 Apr 2010 |
| SQL Server 2008 | ||
| 10.00.4266 | SQL Server 2008 SP2 CU1 | 15 Nov 2010 |
| 10.00.4000 | SQL Server 2008 SP2 | 29 Sep 2010 |
| 10.00.2804 | SQL Server 2008 SP1 CU11 | 15 Nov 2010 |
| 10.00.2799 | SQL Server 2008 SP1 CU10 | 21 Sep 2010 |
| 10.00.2789 | SQL Server 2008 SP1 CU9 | 19 Jul 2010 |
| 10.00.2775 | SQL Server 2008 SP1 CU8 | 17 May 2010 |
| 10.00.2766 | SQL Server 2008 SP1 CU7 | 15 Mar 2010 |
| 10.00.2757 | SQL Server 2008 SP1 CU6 | 18 Jan 2010 |
| 10.00.2746 | SQL Server 2008 SP1 CU5 | 24 Nov 2009 |
| 10.00.2734 | SQL Server 2008 SP1 CU4 | 22 Sep 2009 |
| 10.00.2723 | SQL Server 2008 SP1 CU3 | 21 Jul 2009 |
| 10.00.2714 | SQL Server 2008 SP1 CU2 | 18 May 2009 |
| 10.00.2710 | SQL Server 2008 SP1 CU1 | 16 Apr 2009 |
| 10.00.2531 | SQL Server 2008 SP1 | 7 Apr 2009 |
| 10.00.1835 | SQL Server 2008 RTM CU10 | 15 Mar 2010 |
| 10.00.1828 | SQL Server 2008 RTM CU9 | 18 Jan 2009 |
| 10.00.1823 | SQL Server 2008 RTM CU8 | 16 Nov 2009 |
| 10.00.1818 | SQL Server 2008 RTM CU7 | 21 Sep 2009 |
| 10.00.1812 | SQL Server 2008 RTM CU6 | 21 Jul 2009 |
| 10.00.1806 | SQL Server 2008 RTM CU5 | 18 May 2009 |
| 10.00.1798 | SQL Server 2008 RTM CU4 | 17 Mar 2009 |
| 10.00.1787 | SQL Server 2008 RTM CU3 | 19 Jan 2009 |
| 10.00.1779 | SQL Server 2008 RTM CU2 | 17 Nov 2008 |
| 10.00.1763 | SQL Server 2008 RTM CU1 | 22 Sep 2008 |
| 10.00.1600 | SQL Server 2008 RTM | 6 Aug 2008 |
| SQL Server 2005 | ||
| 9.00.5254 | SQL Server 2005 SP4 CU1 | 20 Dec 2010 |
| 9.00.5000 | SQL Server 2005 SP4 | 17 Dec 2010 |
| 9.00.4315 | SQL Server 2005 SP3 CU13 | 20 Dec 2010 |
| 9.00.4311 | SQL Server 2005 SP3 CU12 | 18 Oct 2010 |
| 9.00.4309 | SQL Server 2005 SP3 CU11 | 17 Aug 2010 |
| 9.00.4305 | SQL Server 2005 SP3 CU10 | 23 Jun 2010 |
| 9.00.4294 | SQL Server 2005 SP3 CU9 | 19 Apr 2010 |
| 9.00.4285 | SQL Server 2005 SP3 CU8 | 16 Feb 2010 |
| 9.00.4273 | SQL Server 2005 SP3 CU7 | 21 Dec 2009 |
| 9.00.4266 | SQL Server 2005 SP3 CU6 | 19 Oct 2009 |
| 9.00.4230 | SQL Server 2005 SP3 CU5 | 17 Aug 2009 |
| 9.00.4226 | SQL Server 2005 SP3 CU4 | 16 Jun 2009 |
| 9.00.4220 | SQL Server 2005 SP3 CU3 | 21 Apr 2009 |
| 9.00.4211 | SQL Server 2005 SP3 CU2 | 17 Feb 2009 |
| 9.00.4207 | SQL Server 2005 SP3 CU1 | 20 Dec 2008 |
| 9.00.4053 | SQL Server 2005 SP3 GDR (Security Update) | 13 Oct 2009 |
| 9.00.4035 | SQL Server 2005 SP3 | 16 Dec 2008 |
| 9.00.3356 | SQL Server 2005 SP2 CU17 | 21 Dec 2009 |
| 9.00.3355 | SQL Server 2005 SP2 CU16 | 19 Oct 2009 |
| 9.00.3330 | SQL Server 2005 SP2 CU15 | 18 Aug 2009 |
| 9.00.3328 | SQL Server 2005 SP2 CU14 | 16 Jun 2009 |
| 9.00.3325 | SQL Server 2005 SP2 CU13 | 21 Apr 2009 |
| 9.00.3315 | SQL Server 2005 SP2 CU12 | 17 Feb 2009 |
| 9.00.3310 | SQL Server 2005 SP2 Security Update | 10 Feb 2009 |
| 9.00.3301 | SQL Server 2005 SP2 CU11 | 15 Dec 2008 |
| 9.00.3294 | SQL Server 2005 SP2 CU10 | 20 Oct 2008 |
| 9.00.3282 | SQL Server 2005 SP2 CU9 | 18 Aug 2008 |
| 9.00.3257 | SQL Server 2005 SP2 CU8 | 16 Jun 2008 |
| 9.00.3239 | SQL Server 2005 SP2 CU7 | 14 Apr 2008 |
| 9.00.3233 | SQL Server 2005 QFE Security Hotfix | 8 Jul 2008 |
| 9.00.3228 | SQL Server 2005 SP2 CU6 | 18 Feb 2008 |
| 9.00.3215 | SQL Server 2005 SP2 CU5 | 17 Dec 2007 |
| 9.00.3200 | SQL Server 2005 SP2 CU4 | 15 Oct 2007 |
| 9.00.3186 | SQL Server 2005 SP2 CU3 | 20 Aug 2007 |
| 9.00.3175 | SQL Server 2005 SP2 CU2 | 28 Jun 2007 |
| 9.00.3161 | SQL Server 2005 SP2 CU1 | 15 Apr 2007 |
| 9.00.3152 | SQL Server 2005 SP2 Cumulative Hotfix | 7 Mar 2007 |
| 9.00.3077 | SQL Server 2005 Security Update | 10 Feb 2009 |
| 9.00.3054 | SQL Server 2005 KB934458 | 5 Apr 2007 |
| 9.00.3042.01 | SQL Server 2005 “SP2a” | 5 Mar 2007 |
| 9.00.3042 | SQL Server 2005 SP2 | 1 Feb 2007 |
| 9.00.2047 | SQL Server 2005 SP1 | |
| 9.00.1399 | SQL Server 2005 RTM | 1 Nov 2005 |
| SQL Server 2000 | ||
| 8.00.2039 | SQL Server 2000 SP4 | |
| 8.00.0760 | SQL Server 2000 SP3 | |
| 8.00.0534 | SQL Server 2000 SP2 | |
| 8.00.0384 | SQL Server 2000 SP1 | |
| 8.00.0194 | SQL Server 2000 RTM | |
| SQL Server 7 | ||
| 7.00.1063 | SQL Server 7 SP4 | |
| 7.00.0961 | SQL Server 7 SP3 | 15 Dec 2000 |
| 7.00.0842 | SQL Server 7 SP2 | 20 Mar 2000 |
| 7.00.0699 | SQL Server 7 SP1 | 15 Jul 1999 |
| 7.00.0623 | SQL Server 7 RTM | |
| SQL Server 6.5 | ||
| 6.50.416 | SQL Server 6.5 SP5a | |
| 6.50.415 | SQL Server 6.5 SP5 | |
| 6.50.281 | SQL Server 6.5 SP4 | |
| 6.50.258 | SQL Server 6.5 SP3 | |
| 6.50.240 | SQL Server 6.5 SP2 | |
| 6.50.213 | SQL Server 6.5 SP1 | |
| 6.50.201 | SQL Server 6.5 RTM |