[EN] SQL Server 2008 Service Pack 4 is available!

LOGO__SQLServer2008Very, very long awaited final Service Pack4 for Microsoft SQL Server 2008 is already available. This Service Pack 4 (build number 10.50.600.34) include whole previously published updates for Service Pack 3 and up to Cumulative Update 17 (sic!). And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 4. So it is the same story like in my previous post: this is the last update for Microsoft SQL Server 2008.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008SP4-KB2979596-x64-ENU.exe | 378.4 MB
  • ENU\SQLServer2008SP4-KB2979596-x86-ENU.exe | 310.9 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 Enterprise Edition
  • SQL Server 2008 Developer Edition
  • SQL Server 2008 Standard Edition
  • SQL Server 2008 Evaluation Edition
  • SQL Server 2008 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 SP4 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft ADOMD.NET 
  • Microsoft Analysis Management Objects 
  • Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
  • Microsoft SQL Server 2008 Command Line Utilities 
  • Microsoft Connector 1.0 for SAP BI 
  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server Remote Blob Store
  • Microsoft SQL Server 2008 Native Client
  • Microsoft Windows PowerShell Extensions for SQL Server
  • Microsoft SQL Service Broker External Activator 
  • Microsoft SQL Server System CLR Types 

and full list of downloadable files:

 

image

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 Express Service Pack 4 refresh.
  • We are not releasing IA64 packages of SQL Server 2008 Service Pack4. For IA64 it is recommended to apply the latest update we delivered on SQL Server 2008 Service Pack 3.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008. To slipstream a SQL Server 2008 with Service Pack 4 please see post.

[EN] SQL Server 2005 SP4 Cumulative Update 3 is now available

LOGO_SQLServer2005Today Microsoft released a series of updates for SQL Server. In a previous post i wrote about cumulative update for SQL Server Service Pack 3. Now it’s time for Service Pack 4.

Cumulative update package no. 3 for SQL Server 2005 SP 4 [version build: 9.00.5266] fixed seven issues in total:
* four issues for SQL Server Engine
* three issues for SQL Server Integration Services

Below You can find short information about fixed bugs:

VSTS BUG: 669144| KB Article:  2489667
FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 651082| KB Article:  2498818
FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

VSTS BUG: 674498| KB Article:  2510788
FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package is aborted

VSTS BUG: 679617| KB Article:  2515286
FIX: "There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005

VSTS BUG: 671319| KB Article:  2511151
FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005 or in SSIS 2008

As the same case in previous package (CU15 for SP3) It’s very important!! Before You trying to install this cumulative updates, You must:

  • SQL Server Install Service Pack 4 – get it HERE
  • enable SMO (SQL Server Management Object) extended stored procedures
  • enable SQL-DMO (SQL Server Distrubuted Manajement Object) extended stored procedures

More information about this release You can find with the article: Cumulative Update 3 for SQL Server 2005 Service Pack 4

If You want to go directly to download seccion go to Request Hotfix Download Site, where You can choose language (English, Spanish, Chinese, French, German, Italian, Russian, Korean, Japanese) and version (for 32-bit, 64-bit, itanium).