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?
@@version
output would say so:Microsoft SQL Server 2008 **R2** (SP1) - 10.50.2500.0 (X64)