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

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 2011. The list is daily updated.

• 2641923 FIX: Incorrect custom color distribution when you use numeric values for the Start Value and the End Value of custom color distribution buckets in SSRS 2008 R2 Q2641923 KB2641923 December 28, 2011
• 2639301 FIX: Error message when you review a SSRS 2008 R2 report that has a tablix data region if the region contains some chart, gauge, or map items Q2639301 KB2639301 December 19, 2011
• 2638216 FIX: Error message when you run a query that uses an MDX reserved keyword as a parameter name in SSAS 2008 R2 Q2638216 KB2638216 December 19, 2011
• 2632021 FIX: A SSRS 2008 R2 report that has toggle items is not paginated Q2632021 KB2632021 December 19, 2011
• 970198 FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008 or in SQL Server 2008 R2 Q970198 KB970198 December 19, 2011
• 2619924 FIX: SQL Server 2008 R2 SP1 does not update the Microsoft.AnalysisServices.SharePoint.Integration.dll module Q2619924 KB2619924 November 17, 2011
• 2535660 FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2 Q2535660 KB2535660 October 18, 2011
• 2624056 FIX: Status window does not have text for process progress when you process SSAS 2008 R2 objects in BIDS or SSMS Q2624056 KB2624056 October 17, 2011
• 2620333 FIX: Globals.TotalPages variable returns an incorrect value in a SSRS 2008 R2 report Q2620333 KB2620333 October 17, 2011
• 2591945 FIX: SSAS 2008 R2 might crash after you install TFS 2010 Q2591945 KB2591945 October 17, 2011
• 2588016 "Internal error: An unexpected exception occurred" error when you run the ProcessUpdate command if you modify the aggregation design of a dimension in SSAS 2008 R2 Q2588016 KB2588016 October 17, 2011
• 2585784 FIX: No row or column headers are displayed in an HTML-formatted SQL Server 2008 R2 report if the LayoutDirection property is set to RTL Q2585784 KB2585784 October 17, 2011
• 2562396 FIX: Exception when an MDX query uses the Crossjoin function in SSAS 2008 R2 if more than 4 billion tuples are returned Q2562396 KB2562396 October 17, 2011
• 972777 FIX: The SQL Server 2008 Analysis Services and SQL Server 2008 R2 Analysis Services service stops responding when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database Q972777 KB972777 October 17, 2011
• 2627092 BIDS can take minutes to load a project with above 100 dimensions Q2627092 KB2627092 October 7, 2011
• 982850 FIX: No result is returned when you run a Multidimensional Expressions (MDX) query that uses the Filter function against a dimension in SQL Server 2008 R2 Q982850 KB982850 October 6, 2011
• 982870 Diagnosing and Troubleshooting SQL Server Performance Problems Q982870 KB982870 October 5, 2011
• 2591295 FIX: SSAS 2008 or SSAS 2008 R2 crashes when you perform synchronization in TFS 2010 after you rebuild a cube Q2591295 KB2591295 October 4, 2011
• 2624458 SSIS Checkpoints are not honored for For Loop or Foreach Loop container items Q2624458 KB2624458 October 3, 2011
• 2600089 Use of virtual host drivers can lead to SQL Server Database Engine data consistency problems Q2600089 KB2600089 September 17, 2011
• 981596 All links on the System Settings page of SharePoint Central Administration function incorrectly after you retract the Powerpivotfarm.wsp solution Q981596 KB981596 September 17, 2011
• 981589 The Nullable property of query parameters is reset incorrectly to “False” in after you save and then reopen a shared dataset in Report Builder 3.0 Q981589 KB981589 September 17, 2011
• 980495 Two shortcuts function incorrectly after you upgrade from SQL Server 2008 to SQL Server 2008 R2 CTPs or from SQL Server 2008 R2 CTPs to SQL Server 2008 R2 RTM Q980495 KB980495 September 17, 2011
• 2291697 FIX: Orphaned entries for the PowerPivot service application database are left in the SharePoint configuration database after you uninstall the PowerPivot service application on a computer that is running SQL Server 2008 R2 Analysis Services Q2291697 KB2291697 September 13, 2011
• 2542061 Using virtual host drivers could lead to data consistency problems with the SQL Server Database Engine Q2542061 KB2542061 August 29, 2011
• 2983037 If PowerPivot exists in both the beta version of a product and in the release version of another product, PowerPivot does not work Q2983037 KB2983037 August 26, 2011
• 983037 If PowerPivot exists in both the beta version of a product and in the release version of another product, PowerPivot does not work Q983037 KB983037 August 26, 2011
• 2587551 Introduction to the Microsoft StreamInsight 1.2 release Q2587551 KB2587551 August 23, 2011
• 2019126 A Data Collector collection set may not be uploaded if a cache file is corrupted Q2019126 KB2019126 August 19, 2011
• 2001026 INF: Space requirements for backup devices in SQL Server Q2001026 KB2001026 August 11, 2011
• 2452789 Introduction to the Microsoft StreamInsight 1.1 release Q2452789 KB2452789 August 5, 2011
• 2565842 Slow performance when you render a report on servers where Symantec Endpoint Protection is installed Q2565842 KB2565842 July 27, 2011
• 2513181 SQL Server 2008 full-text index on XML column do not index attribute values for the inner nodes Q2513181 KB2513181 July 13, 2011
• 2555855 You encounter error messages when you execute linked server queries without the required providers installed Q2555855 KB2555855 June 20, 2011
• 2983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q2983564 KB2983564 May 30, 2011
• 983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q983564 KB983564 May 30, 2011
• 2022254 SQL Server may report an 18272 error during restore operations Q2022254 KB2022254 May 24, 2011
• 953504 How to change SQL Server parameters in a clustered environment when SQL Server is not online Q953504 KB953504 May 16, 2011
• 2075816 StreamInsight Setup incorrectly rejects valid product keys on certain localized operating system versions Q2075816 KB2075816 May 9, 2011
• 974319 FIX: Intermittent error message and assertion failure when you use database mirroring in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'" Q974319 KB974319 April 29, 2011
• 2513216 Microsoft Query lists user objects and system views in the query wizard Q2513216 KB2513216 April 28, 2011
• 2216501 FIX: Multiserver jobs are not downloaded from SQL Server 2000 in the MSX role to SQL Server 2008 or to SQL Server 2008 R2 in the TSX role Q2216501 KB2216501 April 22, 2011
• 2216497 FIX: Spatial Storage geometry polygon data types with internal rings return incorrect data through different geometric operations Q2216497 KB2216497 April 22, 2011
• 2216491 The SQL Dumper utility cannot generate error dump files on a SQL Server 2008 or SQL Server 2008 R2 failover cluster on an Advanced/Enterprise Failover Cluster install Q2216491 KB2216491 April 22, 2011
• 2216478 Error message when you run Get-Command in a PowerShell version 2 environment on a server that is running SQL Server 2008 or SQL Server 2008 R2: "Object reference not set to an instance of an object" Q2216478 KB2216478 April 22, 2011
• 2216460 Error message when you try to open a project in SQL Server 2008 or in SQL Server 2008 R2: "The located assembly's manifest definition does not match the assembly reference" Q2216460 KB2216460 April 22, 2011
• 2105809 You get “Cannot stop ReportServer service on computer <Computer name> “ when switching from Connected mode to Local Mode Q2105809 KB2105809 April 22, 2011
• 981588 You receive an error message when you try to browse directly to the SSRS 2008 R2 report server after you create a SharePoint claim site Q981588 KB981588 April 22, 2011
• 949775 The target server cannot download a multiserver job from the master server if the target server is running a German version or a French version of SQL Server 2005 or a German version of SQL Server 2008 R2 Q949775 KB949775 April 22, 2011
• 2506799 FIX: Performance decreases after you move a large report to SQL Server 2008 R2 Reporting Services Q2506799 KB2506799 April 18, 2011
• 2520691 Updating a view via Linked server query may fail Q2520691 KB2520691 April 14, 2011
• 2983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010 Q2983332 KB2983332 March 24, 2011
• 983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010 Q983332 KB983332 March 24, 2011
• 2481245 FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008 or in SSAS 2008 R2 Q2481245 KB2481245 March 21, 2011
• 2480368 FIX: SSAS 2008 or SSAS 2008 R2 crashes after a ProcessFull operation is performed on a measure group for a server-based cube if SSAS tries to clean a session that contains a session cube Q2480368 KB2480368 March 21, 2011
• 2401548 FIX: An embedded image of a report is incorrectly displayed as a red cross in SQL Server 2008 Reporting Services and in SQL Server 2008 R2 Reporting Services Q2401548 KB2401548 March 21, 2011
• 2163958 FIX: The SQL Server Utility dashboard may report incorrect CPU usage on DAC databases in SQL Server 2008 R2 Q2163958 KB2163958 March 21, 2011
• 2523164 SQL Server configuration changes may not be installed because they have not been reconfigured or SQL Server has not been restarted Q2523164 KB2523164 March 17, 2011
• 2503278 FIX: Incorrect result of a calculated member that references another calculated member if the referenced calculated member is used in a Filter function in SSAS 2008 R2 Q2503278 KB2503278 February 21, 2011
• 2501558 FIX: A Distinct Count measure may return incorrect values if you define aggregations on the non-overlapping partitions in a distinct count measure group in SSAS 2008 R2 Q2501558 KB2501558 February 21, 2011
• 2498880 FIX: Broken Home link in the Report Explorer Web Part in SQL Server 2008 R2 Reporting Services Q2498880 KB2498880 February 21, 2011
• 2496707 FIX: Ragged hierarchy members cannot be referenced by using the "Name Style 2" method in an MDX query for SQL Server 2008 R2 Analysis Services Q2496707 KB2496707 February 21, 2011
• 2495303 FIX: "Report parameter values must be specified" error when you click a hyperlink in an email message to view a SSRS 2008 R2 report Q2495303 KB2495303 February 21, 2011
• 2494447 FIX: You incorrectly receive a logon dialog box when you try to access a SQL Server 2008 R2 Reporting Services Report Manager website Q2494447 KB2494447 February 21, 2011
• 2492329 FIX: Decrease in rendering performance for SQL Server 2008 R2 Reporting Services in SharePoint Integrated mode when a report contains expressions in "Go to URL" actions Q2492329 KB2492329 February 21, 2011
• 2491439 FIX: Error when you try to create an AMO, ADOMD.NET, or XMLA assembly in SQL Server 2008 R2 Q2491439 KB2491439 February 21, 2011
• 2486793 FIX: The parent report incorrectly contains the parameters of child report when you click "Go back to the parent report" in SSRS 2008 R2 SharePoint integrated mode Q2486793 KB2486793 February 21, 2011
• 2486777 FIX: Error message when you display a drillthrough report in the Report Viewer web part control in Microsoft SQL Server 2008 R2 Reporting Services in SharePoint Integrated mode: "rsExecutionNotFound" Q2486777 KB2486777 February 21, 2011
• 2485396 FIX: Error when you use a hard page-break renderer to export a report in SSRS 2008 R2 if the HideDuplicates property is not set to None Q2485396 KB2485396 February 21, 2011
• 2483381 FIX: An application crashes when it closes the last connection to a local cube file in SSRS 2008 R2 Q2483381 KB2483381 February 21, 2011
• 2481926 FIX: "#ERROR" error when you generate a Hyperion Essbase-based report in SQL Server 2008 R2 Reporting Services if a field name contains a dot character Q2481926 KB2481926 February 21, 2011
• 2479681 FIX: "An item with the same key has already been added" error when you export a report to a PDF or TIFF file in SQL Server 2008 Reporting Services and in SQL Server 2008 R2 Reporting Services Q2479681 KB2479681 February 21, 2011
• 2472573 FIX: "Cannot connect to data source '*.xlsx'" error when you try to connect to a PowerPivot gallery workbook by using Report Builder 3.0 in SSRS 2008 R2 SharePoint integrated mode Q2472573 KB2472573 February 21, 2011
• 2454175 FIX: Wrong email subscription is deleted when you use the SharePoint Integrated mode in SSRS 2008 or in SSRS 2008 R2 if you sort the email subscriptions Q2454175 KB2454175 February 21, 2011
• 2424346 FIX: Report is not displayed correctly on a Report Viewer web part when you select "Adjust height to fit zone" in SSRS 2008 R2 Q2424346 KB2424346 February 21, 2011
• 2422081 FIX: The memory usage in SSAS 2008 or SSAS 2008 R2 may be larger than in SSAS 2005 when you create a local cube Q2422081 KB2422081 February 21, 2011
• 980350 FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008 or in SQL Server 2008 R2 Q980350 KB980350 February 21, 2011
• 2479589 FIX:"A call to SQL Server Reconciler failed" error message occurs when you try to add or reinitialize a subscriber of SQL Server Compact 3.5 for a merge publication Q2479589 KB2479589 February 14, 2011
• 2291705 FIX: The AMO assembly for Microsoft SQL Server 2008 R2 has incorrect dependencies on the Microsoft.SharePoint.dll assembly and the Microsoft.AnalysisServices.SharePoint.Integration.dll assembly Q2291705 KB2291705 February 12, 2011
• 2425714 Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database Q2425714 KB2425714 February 3, 2011
• 2280126 SQL Server 2008 full-text query may return false positives using number with more than 9 digits as search predicate condition Q2280126 KB2280126 January 18, 2011
• 2431212 FIX: MHTML-formatted reports are not compliant with section 1194.22 of the Electronic and Information Technology Accessibility Standards when you use SSRS 2008 or SSRS 2008 R2 to generate the report Q2431212 KB2431212 January 17, 2011
• 2430162 FIX: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples" error message occurs when you try to run an MDX query in SSAS 2008 or in SSAS 2008 R2 Q2430162 KB2430162 January 17, 2011
• 2276495 FIX: "File system error" occurs when you try to run a process update operation on a dimension in Microsoft SQL Server 2008 Analysis Services and in Microsoft SQL Server 2008 R2 Analysis Services Q2276495 KB2276495 January 17, 2011
• 2463203 FIX: An analytic grid that is connected to SSAS 2008 R2 returns incorrect data when you apply a filter to the analytic grid in PerformancePoint Dashboard Designer Q2463203 KB2463203 January 5, 2011
• 2465477 Colors get distorted when you copy an Excel worksheet that is exported from Reporting Services Q2465477 KB2465477 January 2, 2011