SQL Server 2008 R2 articles, fixes and updates - Year 2010

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 R2 that have been released in Year 2010. The list is daily updated.

• 2983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983500 KB2983500 December 22, 2010
• 2422010 FIX: A memory leak occurs when you use SQL Server Native Client 10.5 to run prepared statements in an instance of SQL Server Q2422010 KB2422010 December 22, 2010
• 983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983500 KB983500 December 22, 2010
• 2476357 FIX: A Drillthrough report is not displayed if you install CU3 for a SSRS 2008 R2–based add-in application on a SharePoint 2010 server Q2476357 KB2476357 December 20, 2010
• 2462084 FIX: An Excel worksheet has unexpected automatic subtotals when you export a SSRS 2008 R2 report that uses the visibility toggle feature to an Excel workbook Q2462084 KB2462084 December 20, 2010
• 2456499 FIX: Error message when you try to execute a semantic query that is based on a report model project that uses a SQL Server 2008 R2 PDW database as the data source Q2456499 KB2456499 December 20, 2010
• 2452564 FIX: Report server project error in a build, clean, or preview operation in SQL Server 2008 R2 BIDS Q2452564 KB2452564 December 20, 2010
• 2445896 FIX: "An unexpected exception occurred" when you use the MSOLAP.4 provider to connect to an instance of SSAS Q2445896 KB2445896 December 20, 2010
• 2292725 FIX: You experience decreased performance when you run an MDX query in SQL Server 2008 SP1 or in SQL Server 2008 R2 that has cumulative update 5 or a later version of the update package installed Q2292725 KB2292725 December 20, 2010
• 2222267 FIX: Complex calculations in a query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services return incorrect results Q2222267 KB2222267 December 20, 2010
• 982808 A drillthrough report may not work incorrectly correctly if the "Prompt for credentials" option is used in the data sources in SQL Server 2008 Reporting Service or in SQL Server 2008 R2 Reporting Services Q982808 KB982808 December 20, 2010
• 982564 FIX: You cannot run Data Profile Viewer to open a data profile in SQL Server 2008 or in SQL Server 2008 R2 when the server does not have the Integration Services component installed Q982564 KB982564 December 20, 2010
• 2292737 Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled Q2292737 KB2292737 December 17, 2010
• 2466860 How to determine and change the port of an SSAS Instance Q2466860 KB2466860 November 19, 2010
• 2429685 Cannot connect to a named instance of a clustered analysis services Q2429685 KB2429685 November 19, 2010
• 2983577 FIX: The export process never finishes when you export a report that has nested tablix items in SSRS 2008 or in SSRS 2008 R2 to the extensions that are supported by the hard page-break renderers Q2983577 KB2983577 November 15, 2010
• 2983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q2983480 KB2983480 November 15, 2010
• 2983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983429 KB2983429 November 15, 2010
• 2264562 FIX: A full-text query that uses CONTAINS or FREETEXT predicate together with the "OR" operator takes a long time to run in SQL Server 2008 or in in SQL Server 2008 R2 Q2264562 KB2264562 November 15, 2010
• 2248999 FIX: An index corruption occurs when you update a view in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2248999 KB2248999 November 15, 2010
• 2222998 FIX: An incorrect cardinality estimate is returned when you run a query in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2222998 KB2222998 November 15, 2010
• 2220252 FIX: A SQL Server 2005 report that uses the visibility toggles feature runs incorrectly in SQL Server 2008 or in SQL Server 2008 R2 Q2220252 KB2220252 November 15, 2010
• 2200755 FIX: Error message when you run a MDX query in SSAS 2008 or in SSAS 2008 R2 Q2200755 KB2200755 November 15, 2010
• 2028755 FIX: An incorrect result is returned when you run a LIKE query with wildcards and the Latin1_General_100_CS_AS collation in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2028755 KB2028755 November 15, 2010
• 2028406 FIX: Blank spaces between some items are generated incorrectly in a SQL Server 2008 or a SQL Server 2008 R2 report Q2028406 KB2028406 November 15, 2010
• 983577 FIX: The export process never finishes when you export a report that has nested tablix items in SSRS 2008 or in SSRS 2008 R2 to the extensions that are supported by the hard page-break renderers Q983577 KB983577 November 15, 2010
• 983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q983480 KB983480 November 15, 2010
• 983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983429 KB983429 November 15, 2010
• 982034 FIX: The translation feature does not work when you perform a grouping action in an Excel PivotTable that uses SSAS 2008 or SSAS 2008 R2 as the data source Q982034 KB982034 November 15, 2010
• 981888 FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981888 KB981888 November 15, 2010
• 981867 FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008 Q981867 KB981867 November 15, 2010
• 981713 FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981713 KB981713 November 15, 2010
• 981502 FIX: A query that uses a parallel query plan returns different results every time that you run the query in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981502 KB981502 November 15, 2010
• 981120 FIX: Error message when you enable TDE on a database that has the snapshot isolation enabled in SQL Server 2008 or in SQL Server 2008 R2 Q981120 KB981120 November 15, 2010
• 980948 FIX: Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer Q980948 KB980948 November 15, 2010
• 980883 FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q980883 KB980883 November 15, 2010
• 980570 FIX: "Fulltext index error during compression or decompression" error message when you rebuild the full-text search index in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q980570 KB980570 November 15, 2010
• 2406745 How to calculate Previous Period Growth in SQL Server Analysis Services Q2406745 KB2406745 October 20, 2010
• 2418246 You cannot view some of your SSL Certificates in Reporting Services Configuration Manager Q2418246 KB2418246 October 6, 2010
• 2413549 Using large amounts of memory can result in an inefficient plan in SQL Server Q2413549 KB2413549 October 6, 2010
• 2297053 Behavior of compressed backups when appending backups to an existing media set Q2297053 KB2297053 October 4, 2010
• 2020715 You are not able to migrate your Oracle or Sybase databases to a case-sensitive SQL Server database using SSMA Q2020715 KB2020715 October 4, 2010
• 2400023 Agent message code 2812. Could not find stored procedure ‘sp_MSget_min_seqno’. Q2400023 KB2400023 September 15, 2010
• 2152728 SSIS 2008 Import Export Wizard can show numbers instead of data type Q2152728 KB2152728 September 15, 2010
• 2143880 Bugs that are fixed in Microsoft SQL Server 2008 R2 Master Data Services June Update Q2143880 KB2143880 September 8, 2010
• 2019402 "No mapping between account names and security IDs was done" error when adding a node to a SQL Server 2008 Failover Cluster Q2019402 KB2019402 August 25, 2010
• 981881 FIX: "The selected data extension <data extension name> cannot be loaded" error message when you use Report Builder 2.0 to run an SSRS 2008 or SSRS 2008 R2 report that uses a custom data processing extension in server mode Q981881 KB981881 August 16, 2010
• 981814 FIX: SSMS Object Explorer does not display the correct version number for SSIS or for SSRS Q981814 KB981814 August 16, 2010
• 981811 FIX: An error occurs when you update the schema of objects that are in a published database in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981811 KB981811 August 16, 2010
• 2261507 Error message when you install SQL Server 2008 R2 before you run the PreRequisiteInstaller.exe tool Q2261507 KB2261507 August 9, 2010
• 2254325 The new Utility Information data collection set appears as disabled in SQL Server 2008 Service Pack 2 and in SQL Server 2008 R2 Q2254325 KB2254325 July 8, 2010
• 2253391 The execution of a SQL Server Integration Services (SSIS) package stops responding when you enable DTC transactions for a package in Microsoft SQL Server Q2253391 KB2253391 July 7, 2010
• 2120979 StreamInsight 1.0 updates that are released together with Cumulative Update package 2 for SQL Server 2008 R2 Q2120979 KB2120979 June 25, 2010
• 2028769 FIX: An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery Q2028769 KB2028769 June 25, 2010
• 2983286 FIX: "A connection cannot be made" error message in SSAS 2008 or SSAS 2008 R2 when you try to connect to a database Q2983286 KB2983286 June 23, 2010
• 982631 FIX: A SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services report that contains a table with a child group does not comply with the Section 508 standards Q982631 KB982631 June 23, 2010
• 982418 FIX: "An unexpected error occurred" error message when you use the OPENROWSET function to access an SSAS 2008 or SSAS 2008 R2 database Q982418 KB982418 June 23, 2010
• 982417 FIX: A query returns incorrect results for the ChildCount, DrilledDown, and ParentSameAsPrevious properties of a calculated member in SSAS 2008 or SSAS 2008 R2 Q982417 KB982417 June 23, 2010
• 982321 FIX: Error message when you process an index of a partition in SSAS 2008 or SSAS 2008 R2 Q982321 KB982321 June 23, 2010
• 981922 FIX: An assertion failure occurs when you run a parameterized query that has many parameters in SQL Server 2008 or SQL Server 2008 R2 and that has the SHOWPLAN_XML option enabled Q981922 KB981922 June 23, 2010
• 981899 FIX: An exception occurs when you filter or run an MDX query on a database that contains a dynamic set in SSAS 2008 or SSAS 2008 R2 Q981899 KB981899 June 23, 2010
• 2146369 Recommended configuration for local NTLM connections when using Host Headers with Reporting Services Q2146369 KB2146369 June 18, 2010
• 2121098 Recommended Operating System updates and drivers for SQL Server installations Q2121098 KB2121098 June 18, 2010
• 2022909 SQL Server 2008 and SQL Server 2008 R2 are not supported on some Windows Versions Q2022909 KB2022909 June 18, 2010
• 2106218 When you update a 32-bit instance of SQL Server 2008 R2 by using a 64-bit version of the update, the update incorrectly reports success Q2106218 KB2106218 June 12, 2010
• 2025885 In a PowerPivot workbook, when numeric values are converted to strings, the result is different values in different locales when linked tables are updated Q2025885 KB2025885 June 12, 2010
• 2025803 Error: "The file that you selected could not be found" is displayed on a workbook snapshot after you rename a workbook in PowerPivot Gallery Q2025803 KB2025803 June 12, 2010
• 2025779 Error: "An unexpected error occurred (file 'xmvsquery.cpp', line 1741, function 'XMVSColumn::Bind')" when you create a relationship Q2025779 KB2025779 June 12, 2010
• 2025680 In a PowerPivot workbook, when you try to clear the selection for a calculated measure that has an error in its formula, an unhandled exception occurs Q2025680 KB2025680 June 12, 2010
• 2025669 "Unable to load the Vertipaq engine" error message when you work with PowerPivot workbooks that have linked tables that receive data from an external data source Q2025669 KB2025669 June 12, 2010
• 2023490 All options on the PowerPivot tab are displayed as "noop" if your workbook contains an embedded Excel workbook in SQL Server 2008 PowerPivot Q2023490 KB2023490 June 12, 2010
• 2023455 Error: "Failed to delete columns" when you try to delete a column in a PowerPivot window Q2023455 KB2023455 June 12, 2010
• 2022607 "Show Details cannot be completed on a calculated cell” error message when you try to drill through PowerPivot data Q2022607 KB2022607 June 12, 2010
• 2022567 Error: "Same version requirement for multi-server farm" when you install SQL Server 2008 R2 on a SharePoint farm Q2022567 KB2022567 June 12, 2010
• 2022522 You cannot add a new Slicer to your PowerPivot workbook Q2022522 KB2022522 June 12, 2010
• 2022495 In a PowerPivot workbook, you cannot delete a column in the PowerPivot window after you delete a primary key column in the parent table Q2022495 KB2022495 June 12, 2010
• 2022490 In a PowerPivot workbook, the Currency format is not applied to a column whose data type is set to Currency Q2022490 KB2022490 June 12, 2010
• 2022476 Error: "Unknown or Unsupported type: 'TimeSpan'" when you use data feeds as data sources in PowerPivot Q2022476 KB2022476 June 12, 2010
• 2022446 Error: "An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: <connection name>" when you try to reload a PowerPivot workbook Q2022446 KB2022446 June 12, 2010
• 2023790 You cannot use an IPV6 address for the server name in the Analysis Services Connection Manager after you create an SSIS package in a Microsoft SQL Server 2008 R2 environment Q2023790 KB2023790 June 11, 2010
• 2022833 Error: “Failed to retrieve data for this request” when you try to search for an object in the Object Explorer Details window when you are working with SQL Azure databases Q2022833 KB2022833 June 11, 2010
• 2022705 Error: “Unable to load DLL 'SqlServerSpatial.dll'” when you use Report Builder 3.0 in a Microsoft SQL Server 2008 R2 environment Q2022705 KB2022705 June 11, 2010
• 2022669 You cannot successfully complete the installation of a prepared image of SQL Server 2008 R2 Express Q2022669 KB2022669 June 11, 2010
• 2022604 You cannot update a SQL Server 2008 R2 failover instance Q2022604 KB2022604 June 11, 2010
• 2022253 Redirector stops working after you repair an Analysis Service instance in the SharePoint farm Q2022253 KB2022253 June 11, 2010
• 2021125 PowerPivot: An MDX Query Designer window stops responding when you import data from a SQL Server Analysis Services database Q2021125 KB2021125 June 11, 2010
• 2015802 You cannot install SSAS 2008 R2 on a computer that is running Windows XP SP2 Q2015802 KB2015802 June 9, 2010
• 2025873 PowerPivot add-in Help is not always available in SharePoint Q2025873 KB2025873 May 25, 2010
• 2025789 In PowerPivot, an error occurs when you try to use a file name that contains a semicolon with an Odchandler Q2025789 KB2025789 May 25, 2010
• 2025024 You receive a 500 error on your default SharePoint site after you install PowerPivot and WAC Q2025024 KB2025024 May 25, 2010
• 2022595 "PowerPivot service application proxy does not exist in the farm" error message when you try to create your first PowerPivot service application Q2022595 KB2022595 May 25, 2010
• 955829 The installation process of SQL Server 2008 or of SQL Server 2008 R2 may fail if the server alias is defined in the Client Network Utility Q955829 KB955829 May 14, 2010
• 955768 You receive error messages if the VIA protocol is enabled when you restart the SQL Server 2008 service or the SQL Server 2008 R2 service or when you upgrade an instance of SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 Q955768 KB955768 May 14, 2010
• 981595 The PowerPivot usage statistics of a Reporting Services data source are not collected when you use the "From Report" button Q981595 KB981595 May 12, 2010
• 2021871 Icons for health states of database snapshots appear dimmed in Utility Explorer in SQL Server 2008 R2 Q2021871 KB2021871 May 11, 2010
• 2021490 PowerPivot: PowerPivot is not supported in Click-to-Run versions of Microsoft Office Q2021490 KB2021490 May 11, 2010
• 2021480 PowerPivot: "The data refresh job failed because it has been inactive for more than 3600 seconds" error in an Arabic version of the Windows operating system Q2021480 KB2021480 May 11, 2010
• 956177 You receive an exception in SQL Server 2008 when you try to modify the properties of the SQL Server Administrator account by using SQL Server Management Studio Q956177 KB956177 May 11, 2010
• 956158 You receive an error message when you use SQL Server 2008 Reporting Services: "HTTP 401.1 - Unauthorized: Logon Failed" Q956158 KB956158 May 11, 2010
• 955642 You may receive a Transact-SQL error message or an operational error message when you use SQL Server 2008 Management Studio to connect to an instance of SQL Server 2008 Q955642 KB955642 May 11, 2010
• 955504 The repair process for the Setup support files may fail when you try to repair a SQL Server 2008 installation Q955504 KB955504 May 11, 2010
• 981902 You receive DBCC error messages when you run DBCC commands in SQL Server 2008 R2 CTP3 Q981902 KB981902 May 10, 2010
• 981597 You receive an error message in the x64-based Italian version of SQL Server 2008 R2 BIDS when you try to create a project Q981597 KB981597 May 10, 2010
• 981591 Some pages in Books Online cannot be displayed when SQL Server 2008 and SQL Server 2008 R2 are installed on the same computer Q981591 KB981591 May 10, 2010
• 980497 You cannot upload the Utility Information data collection set in SQL Server 2008 R2 Q980497 KB980497 May 10, 2010
• 2015760 How to troubleshoot Msg 7105 in SQL Server Q2015760 KB2015760 April 1, 2010
• 2015759 How to troubleshoot Msg 832 (constant page has changed) in SQL Server Q2015759 KB2015759 April 1, 2010
• 2015753 How to troubleshoot Error 9004 in SQL Server Q2015753 KB2015753 April 1, 2010
• 2009550 No VSS writers are listed when you run the “vssadmin list writers” command in Windows Server 2008 R2 Q2009550 KB2009550 January 20, 2010