How to know if I am running SQL Server 2008 R2? I ran @@version.

This is what it gave me:

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)   Sep 16 2010 19:43:16   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0  (Build 6002: Service Pack 2) 

How do I know if this is r2?
If you were running SQL Server 2008 R2 it would have 10.5.xxx instead of 10.0.xxx.  And it would also say Microsoft SQL Server 2008 R2 ....

You can always find out the named version by the major/minor build number:


10.5 : 2008 R2
10 : 2008
9 : 2005
8 : 2000
...so on and so forth