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

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: