Search results matching tags 'SQL Server 2008' and 'hotfixes'

Cumulative Update #9 for SQL Server 2008 SP3 is available

AaronBertrand — Tue, 22 Jan 2013 10:55:00 GMT

Today Microsoft has released a new cumulative update for SQL Server 2008 SP3.

KB article: KB #2799883
There are three fixes listed at the time of writing
The build number is 10.00.5829.00
Relevant for @@VERSION between 10.00.5500 and 10.00.5828

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

Cumulative Update #8 for SQL Server 2008 SP3 is available

AaronBertrand — Mon, 19 Nov 2012 21:51:00 GMT

Today Microsoft has released a new cumulative update for SQL Server 2008 SP3.

KB article: KB #2771833
There are 9 fixes listed at the time of writing
The build number is 10.00.5828.00
Relevant for @@VERSION between 10.00.5500 and 10.00.5827

It seems clear that Service Pack 2 servicing has been discontinued. So there is even less reason to hold onto those old builds, and every reason to upgrade to Service Pack 3.

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

MS12-070 : Security Updates for all supported versions of SQL Server

AaronBertrand — Wed, 10 Oct 2012 16:57:00 GMT

This week there was a security release for all supported versions of SQL Server. Each version has 32-bit and 64-bit patches, and each version has GDR (General Distribution Release) and QFE (Quick-Fix Engineering) patches. GDR should be applied if you are at the base (RTM or SP) build for your version, while QFE should be applied if you have installed any cumulative updates after the RTM or SP build. (More details here.)

SQL Server 2005

RTM, SP1, SP2, SP3 - not supported
SP4 - GDR = 9.00.5069, QFE = 9.00.5324

SQL Server 2008

RTM, SP1 - not supported
SP2 - GDR = 10.00.4067, QFE = 10.00.4371
SP3 - GDR = 10.00.5512, QFE = 10.00.5826

SQL Server 2008 R2

RTM - not supported
SP1 - GDR = 10.50.2550, QFE = 10.50.2861
SP2 - not affected

SQL Server 2012

RTM: GDR = 11.00.2218, QFE = 11.00.2376
SP1 - not yet supported; should not be affected once SP1 is released.

Now, a couple of oddities you might have noticed:

The security bulletin mentions something about SQL Server instances with Reporting Services installed. Yet the KB articles for individual updates state that all instances of SQL Server are eligible for the update. And the update does, in fact, update sqlservr.exe and @@VERSION, even for systems where SSRS is not installed. So until there is some clarification on this point, I'm going to treat this as a patch for all instances.
Both the GDR and QFE KBs for multiple patches state that the preceding cumulative updates are included. I believe this is a copy & paste error and that the cumulative updates for a specific branch are only included with the QFE patch. I will update here if I get any confirmation on this.

Even if they come back and say, whoops, our bad, the KBs should mention it is SSRS only, and the GDRs do not affect sqlservr.exe and do not include the CU updates, I'm still going to apply the patch everywhere. Why? Well, for consistency, I'd rather have all of my instances at @@VERSION = x, than have the SSRS instances at x and the non-SSRS instances at < x.

Cumulative Update #7 for SQL Server 2008 Service Pack 3 is available

AaronBertrand — Thu, 20 Sep 2012 21:54:00 GMT

Today Microsoft has released a new cumulative update for SQL Server 2008.

Cumulative Update #7 for SQL Server 2008 Service Pack 3

Knowledge Base Article: KB #2738350
At the time of writing, there are 9 fixes listed
The build number is 10.00.5794
Relevant for @@VERSION between 10.00.5500 and 10.00.5793

No word yet on an update for Service Pack 2.

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

July 2012 : Cumulative Updates for SQL Server 2008 are available

AaronBertrand — Tue, 17 Jul 2012 17:48:00 GMT

Today Microsoft has released two new cumulative updates for SQL Server 2008.

Cumulative Update #11 for SQL Server 2008 Service Pack 2

Knowledge Base Article: KB #2715951
At the time of writing, there are two fixes listed
The build number is 10.00.4333
Relevant for @@VERSION between 10.00.4000 and 10.00.4332

Cumulative Update #6 for SQL Server 2008 Service Pack 3

Knowledge Base Article: KB #2715953
At the time of writing, there are 14 fixes listed
The build number is 10.00.5788
Relevant for @@VERSION between 10.00.5500 and 10.00.5787

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

Cumulative Updates available for SQL Server 2008 SP2 & SP3

AaronBertrand — Mon, 21 May 2012 19:35:00 GMT

Today Microsoft has released two new cumulative updates for SQL Server 2008.

Cumulative Update #10 for SQL Server 2008 Service Pack 2

Knowledge Base Article: KB #2696625
At the time of writing, there is one fix listed
The build number is 10.00.4332

Cumulative Update #5 for SQL Server 2008 Service Pack 3

Knowledge Base Article: KB #2696626
At the time of writing, there are four fixes listed
The build number is 10.00.5785

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

SQL Server 2008 Cumulative Updates are available!

AaronBertrand — Tue, 20 Mar 2012 13:39:00 GMT

SQL Server 2008 Service Pack 2 Cumulative Update #9

KB article : http://support.microsoft.com/kb/2673382
Build number is 10.00.4330
7 fixes (5 in database engine, 2 in SSAS)
Relevant for : Builds of SQL Server between 10.00.4000 and 10.00.4329

SQL Server 2008 Service Pack 3 Cumulative Update #4

KB article : http://support.microsoft.com/kb/2673383
Build number is 10.00.5775
10 fixes listed
Relevant for : Builds of SQL Server between 10.00.5000 and 10.00.5774

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

New cumulative Updates for SQL Server 2008 SP2/SP3 are available!

AaronBertrand — Fri, 20 Jan 2012 16:07:00 GMT

On Monday, I completely missed that the SQL Server Release Services team published two cumulative updates for SQL Server 2008. I'd blame jury duty, but that didn't start until Tuesday, and only lasted two days. Well, better late than never.

Cumulative Update #8 for SQL Server 2008 Service Pack 2

KB : http://support.microsoft.com/kb/2648096
Build number : 10.00.4326
Number of fixes : 6
Relevant for : Builds of SQL Server where SELECT @@VERSION yields between 10.00.4000 and 10.00.4325

Cumulative Update #3 for SQL Server 2008 Service Pack 3

KB : http://support.microsoft.com/kb/2648098
Build number : 10.00.5770
Number of fixes : 14
Relevant for : Builds of SQL Server where SELECT @@VERSION yields between 10.00.5000 and 10.00.5769

As usual, I'll post my standard disclaimer here: these updates are NOT for SQL Server 2008 R2 (where @@VERSION will report 10.50.xxxx).

P.S. this is blog post #499. You're probably not counting, but I am. :-)

Cumulative Updates for SQL Server 2008 SP2/SP3 are available

AaronBertrand — Tue, 22 Nov 2011 13:26:00 GMT

Very early this morning, Microsoft released two new cumulative updates for the SQL Server 2008 platform.

Cumulative Update #7 for SQL Server 2008 Service Pack 2

If SELECT @@VERSION is between 10.00.4000 and 10.00.4322
KB article is KB #2617148
There are 18 fixes posted to the KB article
The new build number is 10.00.4323
See the blog post from the SQL Server Release Services team

Cumulative Update #2 for SQL Server 2008 Service Pack 3

If SELECT @@VERSION is between 10.00.5000 and 10.00.5767
KB article is KB #2633143
There are 3 fixes posted to the KB article
The new build number is 10.00.5768
See the blog post from the SQL Server Release Services team

Note: These updates are for SQL Server 2008, *NOT* for SQL Server 2008 R2. Check SELECT @@VERSION; if it shows 10.50.xxxx and not 10.00.xxxx, you're in the wrong place. :-)

Cumulative Update #1 for SQL Server 2008 SP3 is available!

AaronBertrand — Tue, 18 Oct 2011 15:21:00 GMT

The first cumulative update for SQL Server 2008 SP3 is available.

Build number: 10.00.5766
KB Article: KB #2617146
19 fixes

Please note: this update is not for SQL Server 2008 R2 or for SQL Server 2008 with @@VERSION < 10.00.5500.