Archive

Posts Tagged ‘version’

what the service pack of my SQL server

June 16, 2013 2 comments

 

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

 

 

 

 

 

SP_list

 

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

 

Enjoy 🙂

 

Advertisements