SQL Server Versions

To check the product version, level and edition.

SELECT @@Servername ,SERVERPROPERTY ('productversion') ,SERVERPROPERTY ('productlevel') ,SERVERPROPERTY ('edition')

Release	Product Version
SQL Server 2012 RTM	11.0.2100.6
SQL Server 2008 R2 SP2	10.50.4000.0
SQL Server 2008 R2 SP1	10.50.2500.0
SQL Server 2008 R2 RTM	10.50.1600.1
SQL Server 2008 Service Pack 2	10.00.4000.00
SQL Server 2008 Service Pack 1	10.00.2531.00
SQL Server 2008 RTM	10.00.1600.22
SQL Server 2005 Service Pack 4	9.00.5000.00
SQL Server 2005 Service Pack 3	9.00.4035
SQL Server 2005 Service Pack 2	9.00.3042
SQL Server 2005 Service Pack 1	9.00.2047
SQL Server 2005 RTM	9.00.1399
SQL Server 2000 Service Pack 4	8.00.2039
SQL Server 2000 ServicePack 3a	8.00.760
SQL Server 2000 Service Pack 2	8.00.534
SQL Server 2000 Service Pack 1	8.00.384
SQL Server 2000 RTM	8.00.194
SQL Server 7.0 Service Pack 4	7.00.1063
SQL Server 7.0 Service Pack 3	7.00.961
SQL Server 7.0 Service Pack 2	7.00.842
SQL Server 7.0 Service Pack 1	7.00.699
SQL Server 7.0 RTM	7.00.623
SQL Server 6.5 Service Pack 5a Update	6.50.479
SQL Server 6.5 Service Pack 5a	6.50.416
SQL Server 6.5 Service Pack 5	6.50.415
SQL Server 6.5 Service Pack 4	6.50.281
SQL Server 6.5 Service Pack 3	6.50.258
SQL Server 6.5 Service Pack 2	6.50.240
SQL Server 6.5 Service Pack 1	6.50.213
SQL Server 6.5 RTM	6.50.201