logo
DATABASE RESOURCES PRICING ABOUT US

KB2979596 - SQL Server 2008 Service Pack 4 release information

Description

<html><body><p>Describes SQL Server 2008 Service Pack 4 release information.</p><h2>Summary</h2><div class="kb-summary-section section">This article contains important information to read before you install Microsoft SQL Server 2008 Service Pack 4 (SP4). It describes how to obtain the service pack, the list of fixes included in the service pack, how to select the correct download based on your currently installed version, and a list of copyright attributions for the product.<br/><br/><span class="text-base">Note </span>This article serves as a single source of information for finding all documentation related to this service pack. It includes all the information that you previously used to find in the release notes and Readme.txt files. </div><h2>More Information</h2><div class="kb-moreinformation-section section"><h3 class="sbody-h3">How to obtain SQL Server 2008 SP4</h3>SQL Server 2008 SP4 is available for download at the <a href="http://go.microsoft.com/fwlink/?linkid=512814&clcid=0x409" id="kb-link-1" target="_self">SQL Server 2008 SP4 download page</a>. You can download SQL Server 2008 SP4 Feature Pack <a href="http://go.microsoft.com/fwlink/?linkid=512815&clcid=0x409" id="kb-link-2" target="_self">here</a>.<br/> <h3 class="sbody-h3">List of fixes included in SQL Server 2008 SP4</h3>Microsoft SQL Server 2008 service packs are cumulative updates and SQL Server 2008 SP4 upgrade all editions and service levels of SQL Server 2008 to SQL Server 2008 SP4.<br/><br/>This service pack contains fixes from all Cumulative Updates that were released since SP3 for SQL Server 2008. For a full list of fixes from various cumulative updates since SP3, click the following article numbers to view the articles in the Microsoft Knowledge Base. <div class="indent"><span><a href="https://support.microsoft.com/en-us/help/2629969" id="kb-link-3">2629969 </a> The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3 was released </span></div>In addition to the Cumulative Update fixes, this service pack also includes the following fixes.<div class="table-responsive"><table class="table"><tbody><tr class="sbody-tr"><th class="sbody-th">VSTS Bug</th><th class="sbody-th">KB article number</th><th class="sbody-th">Description</th><th class="sbody-th">Fix area</th></tr><tr class="sbody-tr"><td class="sbody-td">2624594</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2920987" id="kb-link-4">2920987 </a></td><td class="sbody-td">FIX: Poor performance when many table-valued parameters are used in SQL Server</td><td class="sbody-td">SQL service</td></tr><tr class="sbody-tr"><td class="sbody-td">2699028</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2877204" id="kb-link-5">2877204 </a></td><td class="sbody-td">FIX: Error 8985 when you run the "dbcc shrinkfile" statement by using the logical name of a file in SQL Server 2008 R2 or SQL Server 2008</td><td class="sbody-td">SQL service</td></tr><tr class="sbody-tr"><td class="sbody-td">2773324</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2888996" id="kb-link-6">2888996 </a></td><td class="sbody-td">FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server by using the SA account and then run DBCC CHECKDB</td><td class="sbody-td">SQL service</td></tr><tr class="sbody-tr"><td class="sbody-td">2943077</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2963668" id="kb-link-7">2963668 </a></td><td class="sbody-td">FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions</td><td class="sbody-td">SQL service</td></tr><tr class="sbody-tr"><td class="sbody-td">2975380</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2994310" id="kb-link-8">2994310 </a></td><td class="sbody-td">FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 or SQL Server 2008 R2</td><td class="sbody-td">SQL service</td></tr><tr class="sbody-tr"><td class="sbody-td">Not applicable</td><td class="sbody-td"><a href="https://support.microsoft.com/en-us/help/2984340" id="kb-link-9">2984340 </a></td><td class="sbody-td">MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014</td><td class="sbody-td">SQL service</td></tr></tbody></table></div><h3 class="sbody-h3">Select the correct file to download and install</h3>The SQL Server 2008 SP4 download page contains the system requirements for installing SQL Server 2008 SP4 and basic installation instructions. For additional documentation about how to upgrade installed SQL Server 2008 components with a SQL Server 2008 servicing update, see <a href="http://technet.microsoft.com/en-us/library/dd638062(v=sql.100).aspx" id="kb-link-10" target="_self">SQL Server 2008 Servicing Documentation</a>.<br/><br/>For more information about how to install SQL Server 2008, see <a href="http://msdn.microsoft.com/en-us/library/bb500469(v=sql.100).aspx" id="kb-link-11" target="_self">SQL Server 2008 Installation</a>.<br/><br/>Use the following table to identify the location and name of the file to download based on your currently installed version. Download pages provide system requirements and basic installation instructions.<br/> <div class="table-responsive"><table class="table"><tbody><tr class="sbody-tr"><th class="sbody-th">Version you currently have installed</th><th class="sbody-th">Action you want to take</th><th class="sbody-th">File to download and install</th></tr><tr class="sbody-tr"><td class="sbody-td">A 32-bit version of any edition of SQL Server 2008 or SQL Server 2008 SP1 or SQL Server 2008 SP2 or SQL Server 2008 SP3</td><td class="sbody-td">Upgrade to the 32-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 32-bit version of SQL Server 2008 RTM Express or SQL Server 2008 SP1 Express or SQL Server 2008 SP2 Express or SQL Server 2008 SP3 Express</td><td class="sbody-td">Upgrade to the 32-bit version of SQL Server 2008 SP4 Express</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 32-bit version of only the client and manageability tools for SQL Server 2008 or SQL Server 2008 SP1 (including SQL Server 2008 Management Studio) or SQL Server 2008 SP2 (including SQL Server 2008 Management Studio) or SQL Server 2008 SP3 (including SQL Server 2008 Management Studio)</td><td class="sbody-td">Upgrade the client and manageability tools to the 32-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 32-bit version of SQL Server 2008 Management Studio Express or SQL Server 2008 SP1 Management Studio Express or SQL Server 2008 SP2 Management Studio Express or SQL Server 2008 SP3 Management Studio</td><td class="sbody-td">Upgrade to the 32-bit version of SQL Server 2008 SP4 Management Studio Express</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x86-ENU.exe<br/> </td></tr><tr class="sbody-tr"><td class="sbody-td">Both of the following:<ul class="sbody-free_list"><li>A 32-bit version of any edition of SQL Server 2008 or SQL Server 2008 SP1 or SQL Server 2008 SP2 or SQL Server 2008 SP3</li><li>A 32-bit version of the client and manageability tools (including SQL Server 2008 RTM Management Studio)</li></ul></td><td class="sbody-td">Upgrade all products to the 32-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 32-bit version of one or more tools from the Microsoft SQL Server 2008 RTM Feature Pack</td><td class="sbody-td">Upgrade the tools to the 32-bit version of Microsoft SQL Server 2008 SP4 Feature Pack</td><td class="sbody-td">One or more files from Microsoft SQL Server 2008 SP4 Feature Pack</td></tr><tr class="sbody-tr"><td class="sbody-td">No 32-bit installation of SQL Server 2008</td><td class="sbody-td">Install Server 2008 express edition including SP4</td><td class="sbody-td"><a href="http://www.microsoft.com/en-us/download/details.aspx?id=27597" id="kb-link-12" target="_self">SQL Server 2008 SP3 – Express Edition</a> and then SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">No 32-bit installation of SQL Server 2008 Management Studio</td><td class="sbody-td">Install SQL Server 2008 Management Studio including SP4</td><td class="sbody-td"><a href="http://www.microsoft.com/en-us/download/details.aspx?id=7593" id="kb-link-13" target="_self">SQLManagementStudio_x86_ENU.exe</a> to install the free SQL Server 2008 Management Studio Express Edition; then, SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 64-bit version of any edition of SQL Server 2008 or SQL Server 2008 SP1 or SQL Server 2008 SP2</td><td class="sbody-td">Upgrade to the 64-bit version of SQL Server 2008 SP3</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 64-bit version of SQL Server 2008 RTM Express or SQL Server 2008 SP1 Express or SQL Server 2008 SP2 Express or SQL Server 2008 SP3 Express</td><td class="sbody-td">Upgrade to the 64-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 64-bit version of only the client and manageability tools for SQL Server 2008 or SQL Server 2008 SP1 (including SQL Server 2008 Management Studio) or SQL Server 2008 SP2 (including SQL Server 2008 Management Studio) or SQL Server 2008 SP3 (including SQL Server 2008 Management Studio)</td><td class="sbody-td">Upgrade the client and manageability tools to the 64-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 64-bit version of SQL Server 2008 Management Studio Express or SQL Server 2008 SP1 Management Studio Express or SQL Server 2008 SP2 Management Studio Express or SQL Server 2008 SP3 Management Studio</td><td class="sbody-td">Upgrade to the 64-bit version of SQL Server 2008 SP4 Management Studio Express</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">Both of the following:<ul class="sbody-free_list"><li>A 64-bit version of any edition of SQL Server 2008 or SQL Server 2008 SP1 or SQL Server 2008 SP2 or SQL Server 2008 SP3</li><li>A 64-bit version of the client and manageability tools (including SQL Server 2008 RTM Management Studio)</li></ul></td><td class="sbody-td">Upgrade all products to the 64-bit version of SQL Server 2008 SP4</td><td class="sbody-td">SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">A 64-bit version of one or more tools from the Microsoft SQL Server 2008 RTM Feature Pack</td><td class="sbody-td">Upgrade the tools to the 64-bit version of Microsoft SQL Server 2008 SP4 Feature Pack</td><td class="sbody-td">One or more files from Microsoft SQL Server 2008 SP4 Feature Pack</td></tr><tr class="sbody-tr"><td class="sbody-td">No 64-bit installation of SQL Server 2008</td><td class="sbody-td">Install SQL Server 2008 including SP4</td><td class="sbody-td">SQL Server 2008 SP3 – Express Edition and then SQLServer2008SP4-KB2979596-x86-ENU.exe</td></tr><tr class="sbody-tr"><td class="sbody-td">No 64-bit installation of SQL Server 2008 Management Studio</td><td class="sbody-td">Install SQL Server 2008 Management Studio including SP4</td><td class="sbody-td">SQLManagementStudio_x64_ENU.exe to install the free SQL Server 2008 Management Studio Express Edition; then, SQLServer2008SP4-KB2979596-x64-ENU.exe</td></tr></tbody></table></div><span class="text-base">Note</span> After you install the service pack, the SQL Service version should be reflected as 10.00.6000.29.<div class="faq-section" faq-section=""><div class="faq-panel"><div class="faq-panel-heading" faq-panel-heading=""><span class="link-expand-image"><span class="faq-chevron win-icon win-icon-ChevronUpSmall"></span></span><span class="bold btn-link link-expand-text"><span class="bold btn-link">Copyright attributions</span></span></div><div class="faq-panel-body" faq-panel-body=""><p></p><div class="kb-collapsible kb-collapsible-collapsed"><ul class="sbody-free_list"><li><span>This product contains software derived from the Xerox Secure Hash Function.</span></li><li><span>This product includes software from the zlib general purpose compression library.</span></li><li><span>Parts of this software are based in part on the work of RSA Data Security, Inc. Because Microsoft has included the RSA Data Security, Inc., software in this product, Microsoft is required to include the following text that accompanied such software: </span><ul class="sbody-free_list"><li><span>Copyright 1990, RSA Data Security, Inc. All rights reserved.</span></li><li><span>License to copy and use this software is granted provided that it is identified as the "RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing this software or this function. License is also granted to make and use derivative works provided that such works are identified as "derived from the RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing the derived work.</span></li><li><span>RSA Data Security, Inc., makes no representations concerning either the merchantability of this software or the suitability of this software for any particular purpose. It is provided "as is" without express or implied warranty of any kind.</span></li></ul><span>These notices must be retained in any copies of any part of this documentation or software.</span></li><li><span>The Reporting Services mapping feature uses data from TIGER/Line Shapefiles that are provided courtesy of the U.S. Census Bureau (<a href="http://go.microsoft.com/fwlink/?linkid=179079" id="kb-link-16" target="_self">http://www.census.gov/</a>). TIGER/Line Shapefiles are an extract of selected geographic and cartographic information from the Census MAF/TIGER database. TIGER/Line Shapefiles are available without charge from the U.S. Census Bureau. To obtain more information about the TIGER/Line shapefiles, go to <a href="http://go.microsoft.com/fwlink/?linkid=179080" id="kb-link-17" target="_self">http://www.census.gov/geo/www/tiger</a>. The boundary information in the TIGER/Line Shapefiles is for statistical data collection and tabulation purposes only; its depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority, rights of ownership, or entitlement, and does not reflect legal land descriptions. Census TIGER and TIGER/Line are registered trademarks of the U.S. Bureau of the Census.</span></li></ul><span>Copyright 2012 Microsoft. All rights reserved.</span><br/> </div></div></div></div></div><h2>References</h2><div class="kb-references-section section"><span>For more information about how to determine the current SQL Server version and edition, click the following article number to go to the article in the Microsoft Knowledge Base:<br/><br/><div class="indent"><a href="https://support.microsoft.com/en-us/help/321185" id="kb-link-18">321185 </a> How to identify your SQL Server version and edition</div></span><span>The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.</span></div></body></html>