Service pack info

Question

Service pack info

Iulian -207023

SSCertifiable

Points: 7639
More actions
July 31, 2016 at 6:54 am

#328753

Comments posted to this topic are about the item Service pack info
August 1, 2016 at 12:52 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

paul s-306273 SSChampion Points: 10730 More actions · Answer 2

paul s-306273

SSChampion

Points: 10730

August 1, 2016 at 2:06 am

#1892872

Nice QOTD.

edwardwill SSCertifiable Points: 5851 More actions · Answer 3

Weird. SELECT @@version does not return SP information, at least not on my machine:

Microsoft SQL Server 2014 - 12.0.4213.0 (X64)

Jun 9 2015 12:06:16

Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

According to https://msdn.microsoft.com/en-us/library/ms177512.aspx Product Version is only returned for Azure.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 4

It should be something like:

Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)

Jun 17 2016 19:14:09

Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Can you try this one:

SELECT SERVERPROPERTY('productlevel') AS ProductLevel;

What does it show ?

Cheers,

Iulian

edwardwill SSCertifiable Points: 5851 More actions · Answer 5

Iulian -207023 (8/1/2016)
It should be something like:
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
Jun 17 2016 19:14:09
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Can you try this one:
SELECT SERVERPROPERTY('productlevel') AS ProductLevel;
What does it show ?
Cheers,
Iulian

ProductLevel

SP1

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 6

edwardwill (8/1/2016)
Iulian -207023 (8/1/2016)
It should be something like:
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
Jun 17 2016 19:14:09
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Can you try this one:
SELECT SERVERPROPERTY('productlevel') AS ProductLevel;
What does it show ?
Cheers,
Iulian
ProductLevel
SP1

I also found an instance with the same SP1 but where @@Version does not show the (SP1).

According to the documentation here: https://msdn.microsoft.com/en-us/library/ms174396.aspx

The SERVERPROPERTY function returns individual properties that relate to the version information whereas the @@VERSION function combines the output into one string. If your application requires individual property strings, you can use the SERVERPROPERTY function to return them instead of parsing the @@VERSION results.

So I would say there is an inconsistency, maybe a bug, in the way @@Version works for 2014 SP1.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

A simple one to start the week. After a week's vacation, I need to get my brain engaged again. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 8

The lack of mention of the Service Pack when querying @@Version might not be a bug from 2014, but one depending on the way it was installed.

My local installation of SQL Server 2012, won't show the SP, but the servers will.

However, the version number can be used to determine the SP installed.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Bobby Russell SSCrazy Points: 2801 More actions · Answer 9

I checked the correct answer, was told it was the correct answer, but was told my answer was wrong. :/

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 10

Luis Cazares (8/1/2016)
The lack of mention of the Service Pack when querying @@Version might not be a bug from 2014, but one depending on the way it was installed.
My local installation of SQL Server 2012, won't show the SP, but the servers will.
However, the version number can be used to determine the SP installed.

Nice explanation, I did not thought about it.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 11

Strange. I selected the right answer but I declared me that my choice was wrong!

SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY('productlevel') as ProductLevel, SERVERPROPERTY('edition') as Edition, SERVERPROPERTY('ProductMajorVersion') as ProductMajorVersion, SERVERPROPERTY('ProductMinorVersion') as ProductMinorVersion

Thanks.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 12

SQL-DBA-01 (8/1/2016)
Strange. I selected the right answer but I declared me that my choice was wrong!
SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY('productlevel') as ProductLevel, SERVERPROPERTY('edition') as Edition, SERVERPROPERTY('ProductMajorVersion') as ProductMajorVersion, SERVERPROPERTY('ProductMinorVersion') as ProductMinorVersion

Did you select both answers? If not, it's considered wrong.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

webrunner SSC-Dedicated Points: 31862 More actions · Answer 13

Thanks - great question.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html