Home > General > what the service pack of my SQL server

what the service pack of my SQL server

 

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
  1. April 2, 2017 at 3:24 pm

    I’d like to find out more? I’d care to find out some additional information.

  2. April 3, 2017 at 9:25 am

    Definitely believe that that you said. Your favourite justification seemed to
    be at the internet the simplest thing to keep in mind of.

    I say to you, I certainly get annoyed whilst other folks think about worries that they just don’t understand about.
    You managed to hit the nail upon the top and defined
    out the whole thing with no need side-effects , folks can take a signal.
    Will probably be back to get more. Thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: