SQL Server 2012 Build List

Question

Post reply

SQL Server 2012 Build List

Viewing 15 posts - 16 through 30 (of 38 total)

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

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 1

Thanks for the notes. I've tracked down those versions and updated the list.

Indianrock SSC-Insane Points: 20333 More actions · Answer 2

Not sure if hotfixes count as builds but there is one that takes it up to 3350

http://support.microsoft.com/kb/2832017

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 3

CU6 for SQL 2012 SP1 is out.

http://support.microsoft.com/kb/2874879

A.J.
DBA with an attitude

LiLorent SSC Rookie Points: 41 More actions · Answer 4

Perhaps this listing is no longer being maintained for SQL 2012? There has been Service Pack 2 released, as well as a hotfix for that release [http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2969896&kbln=en-us]

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 734564

July 22, 2014 at 8:46 am

#1731454

This list has been updated.

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 6

CU1 for SQL Server 2012 SP2 is out too.

http://support.microsoft.com/kb/2976982

A.J.
DBA with an attitude

tdietrich Old Hand Points: 358 More actions · Answer 7

Regarding the comment above the version list: "Note that Service Packs include all builds below that Service Pack level. So any builds listed below Service Pack 1 are included in Service Pack 1. Those below Service Pack 2 (including Service Pack 1), are included in SP2, etc. "

I don't think that is really true.

For example, when SQL 2012 SP2 came out, it only included SQL 2012 SP1 CU1-CU9, it did not include SP1 CU10 or CU11

So even though patching from SP1 CU10 to SP2 moves you to a higher version number, it effectively uninstalls SP1 CU10.

You don't get that back until you upgrade again to SP2 CU1.

And then SP2 CU1 does include SP1 CU10, but it does not include SP1 CU11.

I don't believe there is an SP2 equivalent of SP1 CU11 yet, but I assume there will be an SP2 CU2 soon that will bring everything back into sync.

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 8

tdietrich (7/28/2014)
Regarding the comment above the version list: "Note that Service Packs include all builds below that Service Pack level. So any builds listed below Service Pack 1 are included in Service Pack 1. Those below Service Pack 2 (including Service Pack 1), are included in SP2, etc. "
I don't think that is really true.
For example, when SQL 2012 SP2 came out, it only included SQL 2012 SP1 CU1-CU9, it did not include SP1 CU10 or CU11
So even though patching from SP1 CU10 to SP2 moves you to a higher version number, it effectively uninstalls SP1 CU10.
You don't get that back until you upgrade again to SP2 CU1.
And then SP2 CU1 does include SP1 CU10, but it does not include SP1 CU11.
I don't believe there is an SP2 equivalent of SP1 CU11 yet, but I assume there will be an SP2 CU2 soon that will bring everything back into sync.

Yes and no. In general the SPs have included all CUs, but depending on the release schedule, a particular fix might not make it into the SP, so the CU might have a fix the SP does not. Don't forget also that the SP is a point in time. It doesn't mean that CUs for previous SPs will not be released. Once SP2 comes out, we can get CU11, CU12, CU13, etc. for SP1.

At most a single CU has fixes not included in the SP at the time of release, but this is the exception, not the rule.

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 9

A.J. Wilbur (7/28/2014)
CU1 for SQL Server 2012 SP2 is out too.
http://support.microsoft.com/kb/2976982

Updated and thanks.Saw this a I was out of the office and forgot.

Michael.Beeby Ten Centuries Points: 1288 More actions · Answer 10

Michael.Beeby

Ten Centuries

Points: 1288

January 16, 2015 at 1:52 am

#1770663

11.00.5556 has appeared.

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 11

Michael.Beeby (1/16/2015)
11.00.5556 has appeared.

Thanks, updated

PAH-440118 Ten Centuries Points: 1292 More actions · Answer 12

I have installed SP2 on our SQL2012 but when I run SELECT @@Version it states

[font="Arial Black"]Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

May 14 2014 18:34:29

Copyright (c) Microsoft Corporation

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

[/font]

The build number is SP2 but the text states Service Pack 1. If I try re run the SP2 installation it shows nothing to upgrade.

why does it show SP1 in the text?

tdietrich Old Hand Points: 358 More actions · Answer 13

Everything after the word "on" in the last line is the version of Windows, not the version of SQL.

on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

That's telling you that you are on Service Pack 1 of Windows.

PAH-440118 Ten Centuries Points: 1292 More actions · Answer 14

:-D. DOh! I guess that I should just read the message not guess what it is saying. 😀

Thanks for your reply.

Michael.Beeby Ten Centuries Points: 1288 More actions · Answer 15

just a thought, but maybe this might show required...

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel,

SERVERPROPERTY('Edition') AS Edition,CASE(SERVERPROPERTY('EngineEdition'))

WHEN 1 THEN '1: Personal or Desktop Engine'

WHEN 2 THEN '2: Standard (Standard/Small Business Server/Web and Workgroup)'

WHEN 3 THEN '3: Enterprise (Enterprise/Enterprise Evaluation/Data Center/Developer)'

WHEN 4 THEN '4: Express (Express/Express with Advanced Services/Windows Embedded SQL)'

WHEN 5 THEN '5: SQL Azure'

ELSE 'Returned (enumeration reqd): ' + cast(SERVERPROPERTY('EngineEdition') AS varchar(10)) END AS EngineEdition;