Category: SQL SQL Server
How to find out which version of Microsoft MS SQL Server you are running.
Open SQL Management Studio, right click the server name and select properties.
Or run command:
Select @@version
||Release||Product Version
|SQL Server 2012 Service Pack 1|11.00.3000.00
|SQL Server 2012 RTM |11.00.2100.60
|SQL Server 2008 R2 Service Pack 2|10.50.4000.0
|SQL Server 2008 R2 Service Pack 1|10.50.2500.0
|SQL Server 2008 R2 RTM|10.50.1600.1
|SQL Server 2008 Service Pack 3|10.00.5500.00
|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 Service Pack 3|8.00.760
|SQL Server 2000 Service Pack 3|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
Lifted from: http://support.microsoft.com/kb/321185