Table of Contents
Recently, some of our users reported that they encountered the release notes for SQL Server 2008 SP2.
The one stop solution for all your Windows related problems
This release notes document describes the most common issues that you should be aware of before installing or troubleshooting the Microsoft SQL Server 2008 R2 Service Pack 2. This release notes document applies to all editions of SQL 2007 Server R2 SP2 and is available online only. It is updated periodically.
1.0 New In Service Pack 2
Added Dynamic Management View (DMV) sys.dm_db_stats_properties. This DMV can be used to return statistical properties for a particular table or indexed view of the current database. For example, this DMV returns the number of rows that were selected in error and the number of steps in the histogram.
2.0 Before Installation
For more information about how to upgrade SQL Server 2008 R2, see SQL Server 2008 R2 Maintenance Documentation.
See the SQL Server R2 readme for general information about how to start the installation and SQL Server 08 R2. The Readme document is no doubt available on the installation media.
2.1 Youget The Correct File To Download The Setup
The one stop solution for all your Windows related problems
If your PC is running slow, littered with errors, and prone to crashing, it's time for ASR Pro. This powerful software can quickly fix Windows-related issues, optimize your system performance, and keep your data safe from harm. With ASR Pro, you'll enjoy a faster, more stable PC experience - without the hassle and expense of taking it in for repair. So don't wait - download ASR Pro today!
Use the following table as well to select a file to upload and create. Be sure to resolve the system requirements before installing the Get service. System requirements can be found on the download pages that are usually associated with the board.
| If your currently installed version is correct… | And your family wants… | Download and install… 32-bit version |
|---|---|---|
| variant of any edition of SQL Server 2008 R2 or SQL Server 09 R2 SP1 | Upgrading to SQL Server 2008 R2 SP2 32-bit | SQLServer2008R2SP2-KB2630458-x86-ENU here |
| 32-bit version of SQL Server 2008 R2 RTM Express, possibly SQL Server 2008 R2 SP1 Express | Upgrading to SQL Server 2008 R2 SP2 32-bit | SQLServer2008R2SP2-KB2630458-x86-ENU.exe here |
| Only 32-bit SQL Server 2008 R2 Client and Management Tools or SQL Server 2010 R2 SP1 (including SQL Server 2010 R2 Studio) | Upgrade client management and then management tools to SQL Server 2008 R2 SP2 32-bit transcription | SQLServer2008R2SP2-KB2630458-x86-ENU.exe here |
| 32-bit version of SQL Server 2008 R2 Management Studio Express or SQLServer 2008 R2 SP1 Management Studio Express | Upgrading to the full 32-bit version of SQL Server 2008 SP2 r2 Management Studio Express | SQLManagementStudio_x86_ENU.exe due to here |
| 32-bit version of the SQL Server 2008 R2 or SQL Server 2008 R2 SP1 template and a working 32-bit version of the client with management tools (including SQL Server 2008 R2 RTM Management Studio) | Upgrade all optional components to SQL Server 2008 R2 SP2 32-bit | SQLServer2008R2SP2-KB2630458-x86-ENU.exe follows here |
| 32-bit version of one or more tools from Microsoft SQL Server 2008 R2 Feature Pack | Upgrade tools to the 32-bit version most commonly associated with a Microsoft SQL Server 2008 R2 SP2 feature or package | Received another file from Microsoft SQL Server 2008 R2 SP2 |
| No 32-bit installation of SQL Server 2008 R2 | Install Server 2008 R2 including SP2 | Open SQL Server 2009 R2 SP2 – Express Edition and follow the instructions. |
| No 32-bit installation of SQL Server 2008 R2 Management Studio | Install SQL Server 2008 R2 Management Studio SP2 | SQLManagementStudio_x86_ENU incl..exe from here to install the free version of SQL Server 2008 R2 SP2 Management Studio Express. |
| 64-bit version lubogo edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 | Upgrading to SQL Server 2008 R2 SP2 64-bit | SQLServer2008R2SP2-KB2630458-x64-ENU or SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here |
| 64-bit version of SQL Server 2008 R2 RTM or Express SQL Server 2007 R2 SP1 Express | Upgrading to a specific 64-bit version of SQL Server 2008 R2 SP2 | SQLServer2008R2SP2-KB2630458-x64-ENU.exe or SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here |
| 64-bit Client Management and Tools for SQL Server R2 or SQL Server 2008 R2 SP1 (including SQL Server 2008 R2 Management Studio) | Upgrade Client Management and Tools to 64-bit version pointing to SQL Server 2008 R2 SP2 | SQLServer2008R2SP2-KB2630458-x64-ENU.exe, probably SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here |
| 64-bit version associated with SQL Server 2008 R2 Management Studio Express or SQL Server 2008 R2 SP1 Management Studio Express | Upgrading to my 64-bit version of SQL Server 08 R2 SP2 Management Express | SQLManagementStudio_x64_ENU studio.exe here |
| 64-bit version of any flavor of SQL Server 2008 R2 and SQL Server 2008 R2 SP1 along with 64-bit version of clients and management tools (including SQL Server 2008 R2 Management rtm Studio) | Upgrade all products to SQL Server 2008 R2 SP2 64-bit | SQLServer2008R2SP2-KB2630458-x64-ENU.exe due tohere |
| A 64-bit version of one or more of the tools from Microsoft SQL Server 2008 R2 Feature Pack | Tools is updated to Microsoft SQL Server 2008 R2 SP2 Feature Pack 64-bit translation | One or more file types from Microsoft SQL Server 2008 R2 SP2 Feature Pack |
| Not all 64-bit versions of SQL Server 2008 R2 are installed | Install Server 09 R2 including SP2 | Go to SQL Server 2008 R2 SP2 – Express Edition and follow the instructions. |
| No 64-bit installation of SQL Server 2008 R2 Management Studio | Install SQL Server 2008 R2 Management Studio including SP2 | SQLManagementStudio_x64_ENU.exe here configure it in the free version of SQL Server 2008 R2 SP2 Management Studio Express. | Maximize your computer's potential with this helpful software download.
