SQL Server 2008 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 that have been released in Year 2011. The list is daily updated.

• 2510788 FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package, of an SSIS 2008 package or of an SSIS 2008 R2 package is aborted Q2510788 KB2510788 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
• 2616527 FIX: BIDS 2008 may crash when you use a BDD transformation in a Data Flow task in SSIS 2008 Q2616527 KB2616527 November 29, 2011
• 2608108 FIX: Me.Value is evaluated incorrectly when it is used to access the Value property of a text box in a SSRS 2008 report if the report has a page header or a page footer Q2608108 KB2608108 October 18, 2011
• 2563449 FIX: XML Source component incorrectly validates external metadata even though the ValidateExternalMetadata property is set to False in SSIS 2008 R2 Q2563449 KB2563449 October 18, 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
• 2620333 FIX: Globals.TotalPages variable returns an incorrect value in a SSRS 2008 R2 report Q2620333 KB2620333 October 17, 2011
• 2580224 FIX: Incorrect results when you commit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008 R2 Q2580224 KB2580224 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
• 974559 FIX: Error message when you run a SQL Server 2008 Integration Services package that uses a configuration table in SQL Server Business Intelligence Development Studio: “The connection "<Connection Name>" is not found” Q974559 KB974559 October 10, 2011
• 972937 FIX: A performance issue in which SQL Server Management Studio checks the fragmentation data of an index in a large database Q972937 KB972937 October 9, 2011
• 971780 FIX: You receive an incorrect result when you run a query that uses the LIKE predicate ending in the s% characters Q971780 KB971780 October 9, 2011
• 957387 FIX: No records may be returned when you call the SQLExecute function to execute a prepared statement and you use the SQL Native Client ODBC Driver in SQL Server 2008 Q957387 KB957387 October 8, 2011
• 936223 FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name ... Q936223 KB936223 October 8, 2011
• 2627092 BIDS can take minutes to load a project with above 100 dimensions Q2627092 KB2627092 October 7, 2011
• 979925 FIX: The ddl_event_notification_events notification is registered successfully even when Service Broker is disabled in SQL Server 2008 Q979925 KB979925 October 7, 2011
• 978947 A non-yielding issue may cause a database mirroring failover in SQL Server 2005 and in SQL Server 2008 Q978947 KB978947 October 7, 2011
• 978791 FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008 Q978791 KB978791 October 7, 2011
• 977305 An application stops responding when it connects to SQL Server 2008 or to SQL Server 2005 by using Java Database Connectivity Driver 2.0 Q977305 KB977305 October 7, 2011
• 975565 FIX: The row count is incorrect after you run a "BULK INSERT" statement by using SQL Server JDBC driver 2.0 to insert data into a table Q975565 KB975565 October 7, 2011
• 969210 FIX: Error messages in various reports in Visual Studio 2008 Team Foundation Server Service Pack 1 with SQL Server 2008 Reporting Services Q969210 KB969210 October 7, 2011
• 981838 FIX: An MDX query returns an incorrect result when you run the query by using a clean cache in SSAS 2008 Q981838 KB981838 October 6, 2011
• 981052 Cumulative update package 8 for SQL Server 2008 Service Pack 1 enables Microsoft SQL Server 2008 SP1 Reporting Services report server to integrate with Microsoft SharePoint 2010 products Q981052 KB981052 October 6, 2011
• 980949 FIX: Header rows of a tablix do not always appear at the top of pages in an SSRS 2008 report Q980949 KB980949 October 6, 2011
• 980925 The results of an MDX query on a calculated member do not have the formatting that you defined on the calculated member in SQL Server 2008 Analysis Services Q980925 KB980925 October 6, 2011
• 980252 FIX: An MDX query that references a calculated measure and references a dimension that uses custom rollup formulas returns an incorrect value in SSAS 2008 Q980252 KB980252 October 6, 2011
• 979740 FIX: Error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008: "System.Exception: SelectClipRgn failed: Win32 error:997" Q979740 KB979740 October 6, 2011
• 979737 Report Server stops responding in SQL Server 2008 Reporting Services Q979737 KB979737 October 6, 2011
• 979379 FIX: Charts that are in a tablix of an SSRS 2008 report display incorrect data Q979379 KB979379 October 6, 2011
• 973968 FIX: A query notification event occurs at incorrect intervals and the time-out setting is not honored when you use query notification that is created by using the SqlDependency object in SQL Server 2008 or in SQL Server 2005 Q973968 KB973968 October 6, 2011
• 982900 SQL Merge Replication Non-Convergence Q982900 KB982900 October 5, 2011
• 982899 Forms Based Authentication in Reporting Service Q982899 KB982899 October 5, 2011
• 982895 Analysis SQL Transactional Replication High Latency Q982895 KB982895 October 5, 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
• 967103 The Full Text Search component installation fails when you try to install the SQL Server 2008 database engine from an installation DVD on a computer that has SQL Server 2008 Express edition installed Q967103 KB967103 September 17, 2011
• 2083921 Cumulative update package 9 for SQL Server 2008 Service Pack 1 Q2083921 KB2083921 September 16, 2011
• 2616797 Test article for trouble shooting (DELETE IF REQUIRED) Q2616797 KB2616797 September 8, 2011
• 2616752 Test article for publishing KB failure (DELETE IF REQUIRED) Q2616752 KB2616752 September 8, 2011
• 2574695 File initialization takes a long time for SQL Server database-related operations Q2574695 KB2574695 August 30, 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
• 2216461 SQL Server 2008 setup fails to install on a Windows Server 2008-based cluster mount point Q2216461 KB2216461 July 29, 2011
• 968829 FIX: Error message when you try to upgrade an instance of SQL Server 2005 to SQL Server 2008: "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes" Q968829 KB968829 July 29, 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
• 955695 FIX: When you run a Transact-SQL script in a step of a SQL Server Agent job in SQL Server 2005 or in SQL Server 2008, the result of the Transact-SQL script may be truncated Q955695 KB955695 June 16, 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
• 978839 FIX: A backup operation on a SQL Server 2008 database fails if you enable change tracking on this database Q978839 KB978839 May 26, 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
• 2004738 SQL Failure Occurs During the Installation of HPC Pack 2008 Q2004738 KB2004738 May 2, 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
• 2520691 Updating a view via Linked server query may fail Q2520691 KB2520691 April 14, 2011
• 977444 Cumulative update package 9 for SQL Server 2008 Q977444 KB977444 April 7, 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
• 2497585 FIX: Incorrect newsletter-style report when a text box value extends from one column to another in SSRS 2008 if you use hard-page-break renderer format Q2497585 KB2497585 March 21, 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
• 2478032 FIX: 0xC002F325 error when you run two SSIS 2008 packages at the same time in SQL Server 2008 Integration Services or in SQL Server 2008 R2 Integration Services Q2478032 KB2478032 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
• 975951 You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that contains only IPv6 addresses Q975951 KB975951 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
• 955816 The print operation is unsuccessful when you try to print a multiple-page report or when you try to print many reports in SQL Server 2008 Reporting Services Q955816 KB955816 March 17, 2011
• 976124 FIX: After you install SQL Server 2008 SP1 for the IA-64 version of SQL Server 2008 with Event Tracing for Windows (ETW) installed, SQL Server hangs during startup and cannot be started Q976124 KB976124 March 9, 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
• 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
• 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
• 2467239 Cumulative update package 2 for SQL Server 2008 Service Pack 2 Q2467239 KB2467239 February 10, 2011
• 2467236 Cumulative update package 12 for SQL Server 2008 Service Pack 1 Q2467236 KB2467236 February 10, 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
• 2446498 FIX: "An error occurred during local report processing" error message may occur when you export a report in SQL Server 2008 Reporting Services Q2446498 KB2446498 January 17, 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
• 2263904 FIX: The application stops responding for 100 seconds and then a SoapException exception occurs after an application calls the ReportExecutionService.Render2 method in SQL Server 2008 Reporting Services Q2263904 KB2263904 January 17, 2011
• 2465477 Colors get distorted when you copy an Excel worksheet that is exported from Reporting Services Q2465477 KB2465477 January 2, 2011