1

I am having a sql server 2012 enterprise edition installed on my win 2012 r2 server.

But i am unable to determine whether its installed with service pack or not. how to find out which service pack is installed ? Here is my screen shot, and my screen shot says that , its a ent.edition with version number:11.2.5058.0 .

WHICH-SERVICE-PACK

When I serached in msdn, i didnot see this version number in any of the service packs of sql server 2012.

Improve this question

2 Answers 2

Reset to default
5

You can execute 

SELECT @@VERSION;

Which will give you the relevant information (note the bold, italicised SP1 from the example results)

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 (Build 9200: )

Improve this answer
9
  • i didnt get the above results after entering select @@version;
    – SPDev Jio
    Nov 14, 2016 at 14:37
  • after checking with select @@version query i got the below results : Microsoft SQL Server 2012 - 11.0.2218.0 (X64) Jun 12 2012 13:05:25 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
    – SPDev Jio
    Nov 14, 2016 at 14:38
  • 11.0.2218.0 is the version number i got from SSMS, select @@version. which one should i believe ? whether from this query OR from the sql server configuration manager --> sql server services--->right click --> go to advanved tab, which produces the result as 11.2.5058.0.
    – SPDev Jio
    Nov 14, 2016 at 14:40
  • its very confusing, which one should i believe is the correct version?
    – SPDev Jio
    Nov 14, 2016 at 14:40
  • 2
    @SPDevJio: Judging by your screenshot, you probably have several SQL Server instances. The one you were connected to when running select @@version; was most likely not the one whose properties are shown in your screenshot.
    – Andriy M
    Nov 14, 2016 at 14:45
2

Check out this website.

https://sqlserverbuilds.blogspot.be/

You are at SP2

Improve this answer
2
  • A link is not an answer. Even if your source is correct.
    – RayofCommand
    Nov 14, 2016 at 14:34
  • In this case I guess this can be accepted.
    – Shanky
    Nov 14, 2016 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.