SQL DBA learning curve

Hi all,

you may required to check your SQL service packs .. use below template to compare the same as of JULY 2013 …

use query as

1> select @@version

output ::

Microsoft SQL Server 2008 R2 (SP2) – 10.50.4000.0 (X64)

Jun 28 2012 08:36:30

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2>

SELECT SERVERPROPERTY(‘productversion’)‘productversion’,SERVERPROPERTY(‘productlevel’)‘Servicepack’,SERVERPROPERTY(‘edition’)‘Product Edition’

use below chart for your reference

chart referred from –> http://sqlserverbuilds.blogspot.in/

Enjoy 🙂