Le versioni di Microsoft SQL Server

Elenco delle versioni di Microsoft SQL Server dalla versione 7 alla 2008

Microsoft SQL SERVER 2008 R2

10.50.2500 SQL Server 2008 R2 Service Pack 1 download
10.50.1600 RTM

SQL SERVER 2008

10.00.4000 SQL Server 2008 Service Pack 2 download
10.00.2531 SQL Server 2008 Service Pack 1 download
10.00.1600 RTM

Microsoft SQL SERVER 2005

9.00.5000 SQL Server 2005 Service Pack 4 RTM download
9.00.4035 SQL Server 2005 Service Pack 3 download
9.00.3042 SQL Server 2005 Service Pack 2
9.00.2047 SQL Server 2005 Service Pack 1
9.00.1399 RTM

Microsoft SQL SERVER 2000

8.00.2039 SQL Server 2000 SP4 download
8.00.760 SQL Server 2000 SP3a
8.00.760 SQL Server 2000 SP3
8.00.534 SQL Server 2000 SP2
8.00.384 SQL Server 2000 SP1
8.00.194 RTM

Microsoft SQL SERVER 7

7.00.1063 SQL Server 7.0 Service Pack 4 (SP4) download
7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
7.00.623 SQL Server 7.0 RTM (Release To Manufacturing)

L'elenco riporta solo le versioni pricipali (RTM e Service Pack), per un elenco completo vedi http://www.sqlsecurity.com/FAQs/SQLS...Default.aspx e http://sqlserverbuilds.blogspot.com/

Il link Microsoft con le versioni: http://support.microsoft.com/kb/321185

Per vedere la versione di SQL digita

SQLCopia

SELECT SERVERPROPERTY('productversion') AS [ProductVersion]
  , SERVERPROPERTY ('productlevel') AS [ProductLevel]
  , SERVERPROPERTY ('edition') AS [Edition]

select @@version AS [Version]

da un risultato simile a questo

TextCopia

ProductVersion     ProductLevel    Edition
---------------------------------------------------------------------------
10.50.1600.1        RTM                Developer Edition (64-bit)

(1 row(s) affected)

Version
---------------------------------------------------------------------------
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
	Apr  2 2010 15:48:46 
	Copyright (c) Microsoft Corporation
	Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

(1 row(s) affected)