SQL Server 2008 R2 articles, fixes and updates

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

2121407 FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2 Q2121407 KB2121407 July 30, 2024
2953354 FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server Q2953354 KB2953354 August 21, 2023
2455009 FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2455009 KB2455009 October 18, 2022
2446036 FIX: MOF compilation errors occur and Setup fails for SQL Server 2008 or SQL Server 2008 R2 Q2446036 KB2446036 October 18, 2022
982857 Fix: Distribution Agent fails with error code 20598 when a publication database is configured with the Read Committed Snapshot option Q982857 KB982857 October 18, 2022
2570501 FIX: Performance might be slow when you run a parallel query against a table that has a large amount of spatial data in SQL Server 2008 R2 or SQL Server 2012 Q2570501 KB2570501 August 18, 2022
2950204 FIX: Error when you open a Power View report that has any Bing Map in SQL Server 2008 R2 Q2950204 KB2950204 September 15, 2021
2640027 FIX: SQL Server Agent job fails if you set the job schedule type as "Start automatically when SQL Server Agent starts" in SQL Server 2008 SP2, SQL Server 2008 SP3, SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2 Q2640027 KB2640027 February 24, 2021
3163992 FIX: Incorrect dimension relationships or ProcessUpdate failures when you process a dimension in SSAS 2008 R2 Q3163992 KB3163992 January 26, 2021
3135852 FIX: The encrypted endpoint communication with TLS 1.2 fails when you use SQL Server Q3135852 KB3135852 January 26, 2021
3027857 FIX: Error 832 occurs after you apply update MS14-044 to SQL Server 2008 R2 or SQL Server 2008 Q3027857 KB3027857 January 26, 2021
2994310 FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 R2 or SQL Server 2008 Q2994310 KB2994310 January 26, 2021
2977756 FIX: Same key_guid value for Service Master Key on two VM nodes in SQL Server 2008 R2 Q2977756 KB2977756 January 26, 2021
2977312 FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server Q2977312 KB2977312 January 26, 2021
2975743 FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS Q2975743 KB2975743 January 26, 2021
2971611 FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2 Q2971611 KB2971611 January 26, 2021
2967240 FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server Q2967240 KB2967240 January 26, 2021
2963658 FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server Q2963658 KB2963658 January 26, 2021
2963408 FIX: Error 5180 occurs when you query BLOB column data in SQL Server Q2963408 KB2963408 January 26, 2021
2950189 FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server Q2950189 KB2950189 January 26, 2021
2939277 FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server Q2939277 KB2939277 January 26, 2021
2938476 FIX: Errors when you use export/import data wizard to move data in SQL Server Q2938476 KB2938476 January 26, 2021
2937131 FIX: Access violation occurs when you delete table rows that have delete cascade and query notifications in SQL Server 2008 R2 Q2937131 KB2937131 January 26, 2021
2936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server Q2936984 KB2936984 January 26, 2021
2936328 FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012 Q2936328 KB2936328 January 26, 2021
2933103 FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server Q2933103 KB2933103 January 26, 2021
2932075 FIX: Transactions can’t be committed when a ROLAP query fails with an error in SSAS 2008 R2 SP2 Q2932075 KB2932075 January 26, 2021
2930592 FIX: "The 'DrillthroughContext' parameter is missing a value" error when you use Report Builder 1.0 for SSRS 2008 R2 Q2930592 KB2930592 January 26, 2021
2930239 FIX: Non-yielding scheduler error when outer joining DMVs with a mismatched ON clause in SQL Server 2008 R2 or SQL Server 2012 Q2930239 KB2930239 January 26, 2021
2929464 FIX: SELECT queries deadlock when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2008 R2 Q2929464 KB2929464 January 26, 2021
2928669 FIX: The reports generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards Q2928669 KB2928669 January 26, 2021
2927564 FIX: Poor performance in SSAS 2008 R2 when the number of concurrent users increases Q2927564 KB2927564 January 26, 2021
2927325 FIX: Thesaurus expansion for phrases returns unexpected results in SQL Server 2008 or SQL Server 2008 R2 Q2927325 KB2927325 January 26, 2021
2926699 FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1 Q2926699 KB2926699 January 26, 2021
2926217 FIX: Performance problems occur when database lock activity increases in SQL Server Q2926217 KB2926217 January 26, 2021
2924996 FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server Q2924996 KB2924996 January 26, 2021
2923837 FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server Q2923837 KB2923837 January 26, 2021
2922799 FIX: Unexpected exception is thrown when you convert writeback partition in SSAS Q2922799 KB2922799 January 26, 2021
2921630 FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS Q2921630 KB2921630 January 26, 2021
2919611 FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2 Q2919611 KB2919611 January 26, 2021
2912949 FIX: SSAS crashes when more than one thread tries to access an SSAS cube at the same time Q2912949 KB2912949 January 26, 2021
2912049 FIX: Memory leak occurs when an application that uses SQL Server Native Client tries to connect and close the connection to a SQL Server 2008 R2 instance Q2912049 KB2912049 January 26, 2021
2911026 FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 Q2911026 KB2911026 January 26, 2021
2902858 FIX: SSIS package does not stop running when the package contains a Fuzzy Lookup transformation in SQL Server 2008 R2 Q2902858 KB2902858 January 26, 2021
2902151 FIX: Change Tracking incorrect current versions in database snapshots in SQL Server 2008 R2 Q2902151 KB2902151 January 26, 2021
2895694 FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS Q2895694 KB2895694 January 26, 2021
2893022 FIX: "Could not redo log record" error and log shipping stops working after an automatic failover in SQL Server 2008 R2 Q2893022 KB2893022 January 26, 2021
2892741 FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Q2892741 KB2892741 January 26, 2021
2891115 FIX: "The search text was not found" error when you search for numeric data that contains nonbreaking spaces in SSRS Q2891115 KB2891115 January 26, 2021
2890818 FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS Q2890818 KB2890818 January 26, 2021
2889987 FIX: "Invalid column name '<ColumnName>'" error when you run some MDX queries that you could previously run successfully in SQL Server 2008 R2 or in SQL Server 2012 Q2889987 KB2889987 January 26, 2021
2878968 FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server Q2878968 KB2878968 January 26, 2021
2878807 FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 or SSRS 2012 report or subscription is opened in SharePoint integrated mode Q2878807 KB2878807 January 26, 2021
2878139 FIX: "Using 'dbghelp.dll' version '4.0.5'" error is logged in SQL Server 2012 or SQL Server 2008 R2 when a statement or job executes the sys.fn_xe_file_target_read_file stored procedure Q2878139 KB2878139 January 26, 2021
2877759 FIX: Product prices are changed when you import a catalog in Commerce Server 2009 R2 Q2877759 KB2877759 January 26, 2021
2875949 FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server Q2875949 KB2875949 January 26, 2021
2875690 FIX: Exceptions occur and SSAS crashes after you apply CU12 for SQL Server 2008 R2 SP1 or CU5 for SQL Server 2008 R2 SP2 Q2875690 KB2875690 January 26, 2021
2875260 FIX: It takes longer than expected to create a filtered statistic after you create a clustered index on a partitioned table in SQL Server 2008 R2 Q2875260 KB2875260 January 26, 2021
2866062 FIX: Access violation when you use DTA to analyze a database that contains a partition table in SQL Server 2008 R2 or in SQL Server 2012 Q2866062 KB2866062 January 26, 2021
2861939 FIX: Cannot uninstall, repair, add new features to, or add a new instance to SQL Server 2008 or SQL Server 2008 R2 in Windows 8 Q2861939 KB2861939 January 26, 2021
2859713 FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008, SQL Server 2012 or SQL Server 2008 R2 Q2859713 KB2859713 January 26, 2021
2855755 FIX: Sys.master_files catalog view is updated incorrectly after you change the file growth settings for a database in SQL Server 2008 R2 Q2855755 KB2855755 January 26, 2021
2854420 FIX: An UnhandledReportRenderingException error occurs when a report is rendered in Report Manager in SQL Server 2008 R2 Service Pack 2 or SQL Server 2012 Q2854420 KB2854420 January 26, 2021
2849351 FIX: Error 3241 when you run RESTORE FILELISTONLY statement in SQL Server 2008 R2 or SQL Server 2012 Q2849351 KB2849351 January 26, 2021
2848247 FIX: Slow performance when many connections to a database that run the same query together with different query options in SQL Server 2008 R2 Q2848247 KB2848247 January 26, 2021
2847467 FIX: Poor performance when you run a query that uses the LIKE operator in the WHERE clause in SQL Server 2008 R2 or SQL Server 2012 Q2847467 KB2847467 January 26, 2021
2844210 FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer Q2844210 KB2844210 January 26, 2021
2844196 FIX: Not all results are returned when you perform a full-text search in SQL Server 2008 or SQL Server 2008 R2 Q2844196 KB2844196 January 26, 2021
2843467 FIX: "Internal error" when you run an MDX query after you run an UPDATE CUBE statement in SSAS 2012 or SSAS 2008 R2 Q2843467 KB2843467 January 26, 2021
2837604 FIX: Access violation when you run queries that use the sys.dm_server_services DMV multiple times on several UNION clauses in SQL Server 2012 or SQL Server 2008 R2 Q2837604 KB2837604 January 26, 2021
2833436 FIX: Globals!TotalPages variable returns incorrect number after you perform an in-place upgrade to SSRS 2008 R2 or SSRS 2012 Q2833436 KB2833436 January 26, 2021
2832818 FIX: The KeepTogether property may not work in SSRS 2008 R2 or SSRS 2012 Q2832818 KB2832818 January 26, 2021
2831478 FIX: Incorrect result or access violation when you run an MDX query against an SSAS 2012 or SSAS 2008 R2 database that has multiple data sources Q2831478 KB2831478 January 26, 2021
2829845 FIX: "The provided statistics stream is corrupt" when you run the "UPDATE STATISTICS" statement against a table in SQL Server 2008 R2 or SQL Server 2012 Q2829845 KB2829845 January 26, 2021
2828205 FIX: SQL Server may freeze when an instance of SQL Server 2012, SQL Server 2008 or SQL Server 2008 R2 is shut down Q2828205 KB2828205 January 26, 2021
2823120 FIX: Symmetric key is closed unexpectedly when you alter the symmetric key by dropping a non-existent password in SQL Server 2008 R2 Q2823120 KB2823120 January 26, 2021
2823086 FIX: "The MDX function failed because the coordinate for the 'AttributeName' attribute contains a set." message when you run an MDX query in SQL Server 2012 or in SQL Server 2008 R2 Q2823086 KB2823086 January 26, 2021
2821836 FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2821836 KB2821836 January 26, 2021
2820952 FIX: Query on a role-playing dimension returns incorrect results in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2820952 KB2820952 January 26, 2021
2820918 FIX: PowerPivot database is not deleted from SSAS memory when PowerPivot database processing fails Q2820918 KB2820918 January 26, 2021
2819662 FIX: SQL Server performance issues in NUMA environments Q2819662 KB2819662 January 26, 2021
2819446 FIX: Error when you run the sp_cursoropen stored procedure together with the scrollopt argument in SQL Server 2008 R2 or SQL Server 2012 Q2819446 KB2819446 January 26, 2021
2812884 FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2 Q2812884 KB2812884 January 26, 2021
2809431 FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 Q2809431 KB2809431 January 26, 2021
2809339 FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 or in SSAS 2012 that uses the INT function Q2809339 KB2809339 January 26, 2021
2809198 FIX: Access violation after you run an ALTER statement to add a sparse column to a table in SQL Server 2008 R2 Q2809198 KB2809198 January 26, 2021
2806244 FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based or SQL Server 2012-based log shipping environment Q2806244 KB2806244 January 26, 2021
2806241 FIX: SSRS 2008 R2 report is not displayed if you set the PageBreak property for a group in SQL Server 2008 R2 Q2806241 KB2806241 January 26, 2021
2803994 FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2803994 KB2803994 January 26, 2021
2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2, SQL Server 2008 or SQL Server 2012 Q2803799 KB2803799 January 26, 2021
2802244 FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points Q2802244 KB2802244 January 26, 2021
2802113 FIX: "Failed Assertion = 'CheckValidInput (wsName, cbName)'" error when you use database mirroring in Microsoft SQL Server 2008 R2 Q2802113 KB2802113 January 26, 2021
2801379 FIX: Error 17883 when you run a query on a server that has many CPUs and a large amount of memory in SQL Server 2012 or in SQL Server 2008 R2 Q2801379 KB2801379 January 26, 2021
2800797 FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2 or in SQL Server 2012 Q2800797 KB2800797 January 26, 2021
2800284 FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2 or SSAS 2012 Q2800284 KB2800284 January 26, 2021
2800013 FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012 Q2800013 KB2800013 January 26, 2021
2794260 FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012 Q2794260 KB2794260 January 26, 2021
2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012 Q2791745 KB2791745 January 26, 2021
2791626 FIX: "Incorrect syntax near" error when you use a "datetimeoffset" type column as the partitioning column in SQL Server 2008 R2 Q2791626 KB2791626 January 26, 2021
2790668 FIX: Incorrect result when you use the BCP utility to export data from a SQL Server 2008 R2 instance to a data file Q2790668 KB2790668 January 26, 2021
2788362 FIX: Error 28921 and error 18054 when you start an instance of SQL Server 2008 R2 or SQL Server 2012 that is upgraded from SQL Server 7.0 Q2788362 KB2788362 January 26, 2021
2787595 FIX: An error occurs when you load a thesaurus file in SQL Server 2008 R2 that uses DBCS collation Q2787595 KB2787595 January 26, 2021
2786212 FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2 or in SQL Server 2012 Q2786212 KB2786212 January 26, 2021
2785079 FIX: A "non-yielding" error occurs on a server for Service Broker Message Forwarding in SQL Server 2008 R2 or in SQL Server 2012 Q2785079 KB2785079 January 26, 2021
2784686 FIX: An access violation occurs when you query the missing indexes DMVs in SQL Server 2008 R2 Q2784686 KB2784686 January 26, 2021
2781486 FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2 or SQL Server 2012 Q2781486 KB2781486 January 26, 2021
2781008 FIX: "User cannot be found" error message in SSRS 2008 R2 or in SSRS 2012 after the logon name is changed in Active Directory Q2781008 KB2781008 January 26, 2021
2780146 FIX: "Incorrect syntax near 'IDENTITY_VALUE'" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008 Q2780146 KB2780146 January 26, 2021
2778479 FIX: 17066 and 3624 errors when you run the sp_refreshview stored procedure in a large batch that performs binary large object-related operations in SQL Server 2008 R2 or in SQL Server 2012 Q2778479 KB2778479 January 26, 2021
2778088 FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2778088 KB2778088 January 26, 2021
2777963 FIX: Installation fails when you try to install a cumulative update to an instance of SQL Server 2008 R2 Q2777963 KB2777963 January 26, 2021
2776344 FIX: Deadlocks occur when you execute a stored procedure to alter a temporary table if lock partitioning is enabled in SQL Server 2008 R2 or in SQL Server 2012 Q2776344 KB2776344 January 26, 2021
2770837 FIX: "Windows NT user or group 'Domain_name\User_name' not found" error message when you add a login to a case-sensitive SQL Server 2008 instance or SQL Server 2008 R2 instance Q2770837 KB2770837 January 26, 2021
2770635 FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources Q2770635 KB2770635 January 26, 2021
2770630 FIX: Error message when you run UPDATE CUBE and SELECT MDX statements at the same time in SSAS 2008 R2 Q2770630 KB2770630 January 26, 2021
2770258 FIX: You receive an incorrect result when you run a query against a partitioned table in SQL Server 2008 R2 or in SQL Server 2012 Q2770258 KB2770258 January 26, 2021
2765785 FIX: Access violation when you execute an SSIS 2008 R2 or SSIS 2012 package that contains a Sort transformation on a computer that has multiple CPUs Q2765785 KB2765785 January 26, 2021
2762102 FIX: Incorrect result when you run an MDX query that has an Aggregate function in SSAS 2008 R2 or in SSAS 2012 Q2762102 KB2762102 January 26, 2021
2761600 FIX: Text is truncated in a Tablix control in an report of SSRS 2008 R2 or SQL Server 2012 after you export the report as a PDF or image file Q2761600 KB2761600 January 26, 2021
2761400 FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012 Q2761400 KB2761400 January 26, 2021
2757356 FIX: "The component is waiting for a notification" error message and SSIS 2012 or SSIS 2008 R2 package stops responding when you use Microsoft Connector 1.1 for SAP BI to extract data from SAP BW Q2757356 KB2757356 January 26, 2021
2756471 FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2756471 KB2756471 January 26, 2021
2755767 FIX: A transaction log restore operation takes longer than expected and a 3402 error occurs if a database file is removed in SQL Server 2008 R2 or in SQL Server 2012 Q2755767 KB2755767 January 26, 2021
2755192 FIX: SSMS freezes when you perform management operations that relate to roles to an SSRS 2008 R2 or SSRS 2012 database Q2755192 KB2755192 January 26, 2021
2755079 FIX: Changes are not synchronized to subscribers after you change an article filter in a transactional replication publication in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2755079 KB2755079 January 26, 2021
2754800 FIX: Error 17066 when you replicate a table article that contains an ntext data type column in SQL Server 2008 R2 or in SQL Server 2012 Q2754800 KB2754800 January 26, 2021
2754301 FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2 or in SQL Server 2012 Q2754301 KB2754301 January 26, 2021
2752432 FIX: High CPU usage when you query a binary large object column by using the NOLOCK hint in SQL Server 2008 R2 or in SQL Server 2012 Q2752432 KB2752432 January 26, 2021
2749913 FIX: Unhandled exception when you use a marked transaction that spans multiple databases in SQL Server 2008 R2 or in SQL Server 2012 Q2749913 KB2749913 January 26, 2021
2749560 FIX: "SQL Server Assertion: File: <bcmdsink.cpp>, line=<n> Failed Assertion = 'src'" error message when you update BLOB data in SQL Server 2008 R2 or in SQL Server 2012 Q2749560 KB2749560 January 26, 2021
2744760 FIX: Empty or incomplete tree view is shown in the Process Progress window when you process an SSAS object in SSMS or BIDS in SQL Server 2008 R2 Q2744760 KB2744760 January 26, 2021
2741143 FIX: Incorrect results when you run an MDX query in ROLAP storage mode in SQL Server 2008 R2 Analysis Services Q2741143 KB2741143 January 26, 2021
2740507 FIX: "Cannot get the supported data types from the database connection" error message when you use the Import and Export Data Wizard to connect to a Sybase database in SQL Server 2008 R2 or in SQL Server 2012 Q2740507 KB2740507 January 26, 2021
2737499 FIX: KeepTogether property does not work when you generate a report that contains a tablix in SSRS 2008 R2 or in SSRS 2012 Q2737499 KB2737499 January 26, 2021
2737161 FIX: Cannot add an article to a publication that is in a database mirroring partnership in SQL Server 2008 or in SQL Server 2008 R2 Q2737161 KB2737161 January 26, 2021
2734191 FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2 or in SSRS 2012 Q2734191 KB2734191 January 26, 2021
2733673 FIX: "Ad hoc updates to system catalogs are not allowed" error message when you use SSMS for SQL Server 2008 R2 or SQL Server 2012 to change linked Server properties Q2733673 KB2733673 January 26, 2021
2732742 FIX: Performance decreases when you run a parallel query after you upgrade from SQL Server 2008 to SQL Server 2008 R2 Q2732742 KB2732742 January 26, 2021
2731068 FIX: "An unexpected error occurred" when you query some calculation data of an SSAS tabular model by using SQL Server 2008 R2 PowerPivot for Excel 2010 or SQL Server 2008 R2 PowerPivot for SharePoint 2010 Q2731068 KB2731068 January 26, 2021
2730795 FIX: You cannot delete a consolidated or collection member from an entity in SQL Server 2008 R2 Q2730795 KB2730795 January 26, 2021
2729495 FIX: "The syntax of the string representation of a datetime value is incorrect" error when you use SQL Server 2008 R2 PowerPivot for Excel 2010 Q2729495 KB2729495 January 26, 2021
2728534 FIX: "A system assertion check has failed" error when you re-create a nonclustered index on a column in SQL Server 2008 R2 or in SQL Server 2012 Q2728534 KB2728534 January 26, 2021
2727322 FIX: Incorrect results are returned when you run a query that uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2727322 KB2727322 January 26, 2021
2723474 FIX: Event ID 322 even though operations are successfully completed in SQL Server 2008 or in SQL Server 2008 R2 Q2723474 KB2723474 January 26, 2021
2723232 FIX: "A database error has occurred. Contact your system administrator" error message occurs when you try to populate the business rule of an entity in SQL Server 2008 R2 MDS Q2723232 KB2723232 January 26, 2021
2722165 FIX: A restore operation does not stop at the time that you defined in SQL Server 2008 R2 Q2722165 KB2722165 January 26, 2021
2721122 FIX: "Could not open embedded Powerpivot data" error when a non-administrator user starts SQL Server 2012 PowerPivot for Excel 2010 Q2721122 KB2721122 January 26, 2021
2719217 FIX: Latch time-out error when you have heap tables and when data compression is enabled in SQL Server 2008 R2 or in SQL Server 2012 Q2719217 KB2719217 January 26, 2021
2718920 FIX: SQL Server Agent logs verbose logs in the Application log when you start a failover cluster instance in SQL Server 2012 or in SQL Server 2008 R2 Q2718920 KB2718920 January 26, 2021
2715512 FIX: Error messages when you use dtexec to execute packages in SSIS 2008, in SSIS 2012 or in SSIS 2008 R2 Q2715512 KB2715512 January 26, 2021
2715312 FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2 or in SQL Server 2012 Q2715312 KB2715312 January 26, 2021
2715289 FIX: Incorrect results when you convert a datetimeoffset column to a smalldatetime column in SQL Server 2008 R2 or in SQL Server 2012 when there is an index on the datetimeoffset column Q2715289 KB2715289 January 26, 2021
2714634 FIX: SQL Server 2008 R2 or SQL Server 2012 takes a long time to generate scripts for a partitioned table that uses the data compression feature Q2714634 KB2714634 January 26, 2021
2713501 FIX: A deadlock occurs when you alter a partition and run a statement against the partition at the same time in SQL Server 2008 R2 Q2713501 KB2713501 January 26, 2021
2713151 FIX: Access violation when you use Database Engine Tuning Advisor to tune a table in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 if you enable the "Include filtered indexes" check box Q2713151 KB2713151 January 26, 2021
2711189 FIX: Some events are missing when you run an SSIS package by using the dtexec utility (DTExec.exe) or the SQL Server Agent in SQL Server 2008 R2 Q2711189 KB2711189 January 26, 2021
2708726 FIX: Performance Monitor .dll files in the system32 folder are not updated after you apply updates to SQL Server 2008 R2 or to SQL Server 2012 Q2708726 KB2708726 January 26, 2021
2708012 FIX: Event ID 833 if I/O write operation occurs during a VSS snapshot backup in SQL Server 2008 R2 Q2708012 KB2708012 January 26, 2021
2706601 FIX: Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services Q2706601 KB2706601 January 26, 2021
2706519 FIX: An exception occurs when the SqlCommandBuilder.DeriveParameters method is used to retrieve parameter information from a CLR stored procedure in SQL Server 2008 R2 Q2706519 KB2706519 January 26, 2021
2705236 FIX: An access violation occurs when you run a query that both uses the PIVOT operator and uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2705236 KB2705236 January 26, 2021
2703214 FIX: SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert and an OS error occurs Q2703214 KB2703214 January 26, 2021
2699687 FIX: "Multiple-step OLE DB operation generated errors" error when you insert DATETIME type data to a SMALLDATETIME type column in SQL Server 2008 R2 Q2699687 KB2699687 January 26, 2021
2698639 FIX: Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2 or in SQL Server 2012 Q2698639 KB2698639 January 26, 2021
2696161 FIX: Error message when you try to view a report in SSRS 2012, in SSRS 2008 R2 or in SSRS 2008: "Different query parameters resulted in a same hash" Q2696161 KB2696161 January 26, 2021
2689903 FIX: A non-convergence occurs when you run a merge replication publication that uses web synchronization if the value of a column is NULL in SQL Server 2008 R2 or in SQL Server 2012 Q2689903 KB2689903 January 26, 2021
2685132 FIX: The log shipping restore job restores a corrupted transaction log backup to a secondary database when you run a log shipping backup job on an instance of SQL Server 2008 R2 or an instance of SQL Server 2012 Q2685132 KB2685132 January 26, 2021
2682819 FIX: SQL Server 2008 R2 may stop responding when you perform many Update Cube writeback transactions on multiple cubes that belong to different SSAS 2008 R2 or SSAS 2012 databases Q2682819 KB2682819 January 26, 2021
2682488 FIX: Backup operation fails in a SQL Server database after you enable change tracking Q2682488 KB2682488 January 26, 2021
2681514 FIX: Replication Log Reader Agent crashes when an empty string is inserted into an XML column of a table in a transactional replication publication in SQL Server 2008 R2 Q2681514 KB2681514 January 26, 2021
2680799 FIX: Error message when you perform a full population of a full-text index by using word breakers for Chinese language in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2680799 KB2680799 January 26, 2021
2679342 FIX: The field list of the dataset disappears unexpectedly when a report uses a query as a dataset that includes named parameters in SQL Server 2008 R2 or in SQL Server 2012 Q2679342 KB2679342 January 26, 2021
2678796 FIX: You cannot search a Word document or an Excel workbook that is exported from an SSRS 2008 R2 or an SSRS 2012 report by using a keyword in the content of the document or of the workbook in SharePoint 2010 Q2678796 KB2678796 January 26, 2021
2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 Q2675522 KB2675522 January 26, 2021
2675233 FIX: Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2 or in SSAS 2012 Q2675233 KB2675233 January 26, 2021
2674636 FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2 or in SQL Server 2012 Q2674636 KB2674636 January 26, 2021
2673997 FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012 Q2673997 KB2673997 January 26, 2021
2673056 FIX: SQL Server Configuration Manager takes a long time to open if many SQL Server 2008 R2 or SQL Server 2012 instances are installed Q2673056 KB2673056 January 26, 2021
2671078 FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2671078 KB2671078 January 26, 2021
2669148 FIX: Exception might occur when you run a parallel query that contains a CLR UDA function in SQL Server 2008 R2 or in SQL Server 2012 Q2669148 KB2669148 January 26, 2021
2667742 FIX: "out of memory" error when you use ODBC with SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 Q2667742 KB2667742 January 26, 2021
2665649 FIX: "bufferLen >= colLen" assertion when you run a parallel query in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2665649 KB2665649 January 26, 2021
2662301 FIX: Slow performance occurs in SQL Server 2008 R2 or in SQL Server 2012 if high CPU usage is observed with contention over the QUERY_EXEC_STATS spinlock Q2662301 KB2662301 January 26, 2021
2661644 FIX: Access violation in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2 or in SQL Server 2012 Q2661644 KB2661644 January 26, 2021
2660646 FIX: Incorrect result is returned when the STUnion() method is called between a geometry instance and a GEOMETRYCOLLECTION instance in a query in SQL Server 2008 Q2660646 KB2660646 January 26, 2021
2659075 FIX: Permissions across multiple roles are not additive as expected in SSAS 2008 R2 Q2659075 KB2659075 January 26, 2021
2658474 FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658474 KB2658474 January 26, 2021
2658234 FIX: Unnecessary updates to a subscriber after you reinitialize it if a new article is added to a publication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658234 KB2658234 January 26, 2021
2658214 FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012 Q2658214 KB2658214 January 26, 2021
2653917 FIX: "The data refresh job failed because it has been inactive for more than 3600 seconds" error message when you use SQL Server 2008 R2 PowerPivot for SharePoint in some non-English environments Q2653917 KB2653917 January 26, 2021
2653893 FIX: It takes a long time to restore a database in SQL Server 2008 R2 or in SQL Server 2008 or in SQL 2012 Q2653893 KB2653893 January 26, 2021
2653857 FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version Q2653857 KB2653857 January 26, 2021
2651629 FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2651629 KB2651629 January 26, 2021
2649913 FIX: Performance might decrease when you run a query that uses the sp_cursoropen stored procedure after you upgrade from SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 or to SQL Server 2012 Q2649913 KB2649913 January 26, 2021
2649359 FIX: An access violation occurs in the "sqlservr!CSbMsgDispatcher::CSbReceivedDialog::AppendMsg" class in SQL Server 2008 R2 or in SQL Server 2012 Q2649359 KB2649359 January 26, 2021
2648158 FIX: "The process could not execute" error message when you set a nonzero value in the MaxCmdsInTran parameter of the Log Reader Agent in SQL Server 2008 R2 or in SQL Server 2012 Q2648158 KB2648158 January 26, 2021
2646224 FIX: Query plan is displayed as an XML document incorrectly when you set the SHOWPLAN_XML option to ON in SQL Server 2008 R2 SP1 Q2646224 KB2646224 January 26, 2021
2645648 FIX: Export procedure fails when you export a 64-bit SSRS 2008 R2 report, SSRS 2012 report or a SSRS 2008 report that contains multiple levels of a document map to the PDF format Q2645648 KB2645648 January 26, 2021
2644794 FIX: False assertion error when you try to convert the value from an XML column to an XML variable in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2644794 KB2644794 January 26, 2021
2644396 FIX: Merge replication changes are missing on a SQL Server subscriber when they subscribe to a partition in SQL Server 2008 R2 or in SQL Server 2012 Q2644396 KB2644396 January 26, 2021
2641971 FIX: "Error: Data conversion failed" error when you use multiple characters as the column delimiter in Flat File Connection Manager in SSIS 2008 R2 Q2641971 KB2641971 January 26, 2021
2638448 FIX: Access violation when a query is compiled or recompiled in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2638448 KB2638448 January 26, 2021
2637802 FIX: Pages of an SSRS 2008 R2 or an SSRS 2012 report are delivered incorrectly if you use the ReportExecutionService.Render method to render the report in image format or in EMF format Q2637802 KB2637802 January 26, 2021
2637503 FIX: The storage engine reads the same date dimension two times when you run an MDX query that uses a YTD calculation in SSAS 2008 R2 or in SSAS 2012 Q2637503 KB2637503 January 26, 2021
2636425 FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2 or in SQL Server 2012 Q2636425 KB2636425 January 26, 2021
2635827 FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2 Q2635827 KB2635827 January 26, 2021
2633357 FIX: "Non-yielding Scheduler" error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2 Q2633357 KB2633357 January 26, 2021
2633271 FIX: SQL Server services cannot be stopped on a computer that has SQL Server 2008 R2 Express Edition installed Q2633271 KB2633271 January 26, 2021
2629456 FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2 Q2629456 KB2629456 January 26, 2021
2629168 FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2 or in SSAS 2012 Q2629168 KB2629168 January 26, 2021
2628712 FIX: An infinite loop occurs in a hierarchy that contains a circular relationship in SQL Server 2008 R2 Q2628712 KB2628712 January 26, 2021
2628126 FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column Q2628126 KB2628126 January 26, 2021
2626637 FIX: DRILLTHROUGH statement does not work if it is run against some attribute members whose values contain one or more double quotation marks in SSAS 2008 R2 or in SSAS 2012 Q2626637 KB2626637 January 26, 2021
2626246 FIX: Incorrect results when you run a query against a database that has a 90 collation in SQL Server 2008 or in SQL Server 2008 R2 Q2626246 KB2626246 January 26, 2021
2625768 FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2 Q2625768 KB2625768 January 26, 2021
2624527 FIX: Clustered index is not used in the execution plan in SQL Server 2008 R2 if a query uses two or more partitions Q2624527 KB2624527 January 26, 2021
2624272 FIX: Error 9013 when you try to start the SQL Server services after you apply SQL Server 2008 R2 SP1 for SQL Server 2008 R2 Q2624272 KB2624272 January 26, 2021
2622823 FIX: ghost_record_count values keep increasing in SQL Server 2008 R2 or in SQL Server 2008 Q2622823 KB2622823 January 26, 2021
2621453 FIX: Default name is incorrectly used in SQL Server 2008 R2 if you run a command-line script to install an instance of SQL Server at the command prompt Q2621453 KB2621453 January 26, 2021
2620762 FIX: Acknowledgement messages are not sent by a SQL Server 2008 R2 Service Broker target Q2620762 KB2620762 January 26, 2021
2618680 FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver Q2618680 KB2618680 January 26, 2021
2618676 FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2 Q2618676 KB2618676 January 26, 2021
2616718 FIX: Poor performance when you synchronize the data from a SQL Server 2008 R2 or a SQL Server 2012 publisher to a SQL Server compact 3.5 subscriber Q2616718 KB2616718 January 26, 2021
2616481 FIX: SSRS 2008 R2 report or SSRS 2012 report has no Export menu in Internet Explorer 9.0 if you use the out-of-box viewer page in the SharePoint Report Viewer Web Part Q2616481 KB2616481 January 26, 2021
2616117 FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2 Q2616117 KB2616117 January 26, 2021
2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012 Q2606883 KB2606883 January 26, 2021
2606301 FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008 or in SQL Server 2008 R2 Q2606301 KB2606301 January 26, 2021
2606211 FIX: Error when a complex MDX query has the NONEMPTY clause in SSAS 2008 R2 or in SSAS 2012 if the WHERE clause has a named set Q2606211 KB2606211 January 26, 2021
2605756 FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008, to SSAS 2008 R2 or to SSAS 2012 Q2605756 KB2605756 January 26, 2021
2603910 FIX: Backup fails in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you enable change tracking on the database Q2603910 KB2603910 January 26, 2021
2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2598903 KB2598903 January 26, 2021
2592060 FIX: "A column named 'AttributeName' already belongs to this DataTable" error when you open an entity in Master Data Manager in SQL Server 2008 R2 MDS Q2592060 KB2592060 January 26, 2021
2591902 FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012 Q2591902 KB2591902 January 26, 2021
2591461 FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2 Q2591461 KB2591461 January 26, 2021
2590973 FIX: Exception may occur when you click the label for a report in BIDS for SQL Server 2008 R2 Q2590973 KB2590973 January 26, 2021
2590839 FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012 Q2590839 KB2590839 January 26, 2021
2590200 FIX: "The results of the current statement cannot be stored on the server" error when UpdateCells commands concurrently perform many writeback operations in SSAS 2008 R2 or in SSAS 2012 Q2590200 KB2590200 January 26, 2021
2588970 FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times Q2588970 KB2588970 January 26, 2021
2588506 FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 or in SQL Server 2008 R2 if more than 2100 query parameters are sent Q2588506 KB2588506 January 26, 2021
2588050 FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed Q2588050 KB2588050 January 26, 2021
2588047 FIX: MDX query incorrectly returns a NULL value in SSAS 2008 R2 or in SSAS 2012 if a linked cube contains a many-to-many dimension and a distinct count measure group Q2588047 KB2588047 January 26, 2021
2587511 FIX: Error when a SQL Server performance condition alert is raised in SQL Server 2008 R2 Q2587511 KB2587511 January 26, 2021
2585885 FIX: INSERT or DELETE statements are replicated to the wrong table partition in SQL Server 2008 R2 if you run an ALTER TABLE statement that contains the SWITCH PARTITION command Q2585885 KB2585885 January 26, 2021
2584903 FIX: Data Collector job takes a long time to clear data from an MDW database in SQL Server 2008 or SQL Server 2008 R2 Q2584903 KB2584903 January 26, 2021
2583994 FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops Q2583994 KB2583994 January 26, 2021
2583052 FIX: The installation is not completed successfully when you try to install the Traditional Chinese edition of SQL Server 2008 R2 on a computer that is running the Traditional Chinese edition of Windows Server 2008 Q2583052 KB2583052 January 26, 2021
2576118 FIX: SSIS does not transfer a Flat File source data if the delimiter consists of two characters in SSIS 2008 R2 or SSIS 2008 Q2576118 KB2576118 January 26, 2021
2574973 FIX: Size of a data file that is committed by online page compression is larger than that is committed by offline page compression in SQL Server 2008 or in SQL Server 2008 R2 Q2574973 KB2574973 January 26, 2021
2574714 FIX: Incorrect results when an MDX query runs against an SSAS 2008 or an SSAS 2012 database if you set the RealTimeOlap property to True Q2574714 KB2574714 January 26, 2021
2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system Q2574699 KB2574699 January 26, 2021
2569923 FIX: Upload jobs of data collector quickly open and close a large number of TCP ports if the jobs upload data to a MDW database in SQL Server 2008 or in SQL Server 2008 R2 Q2569923 KB2569923 January 26, 2021
2567763 FIX: Aggregation design assignments are removed in SSAS 2008 R2 if you run the Analysis Services Deployment Wizard to deploy a database by enabling the Retain Partitions option Q2567763 KB2567763 January 26, 2021
2567366 FIX: Slow performance when you restore a database in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 if CDC is enabled Q2567366 KB2567366 January 26, 2021
2566163 FIX: Poor performance when table-valued functions use many table variables in SQL Server 2008 R2 or SQL Server 2008 Q2566163 KB2566163 January 26, 2021
2565683 FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment Q2565683 KB2565683 January 26, 2021
2563924 FIX: "The incoming tabular data stream (TDS) protocol stream is incorrect" error when the SQLPutData function inserts the SQL_NULL_DATA value in a TVP in SQL Server 2008 R2 Q2563924 KB2563924 January 26, 2021
2563828 FIX: Assertion failure when you open a linked report in SQL Server 2008 R2 if the order of the parameters in the source report are changed Q2563828 KB2563828 January 26, 2021
2563216 FIX: Dynamic image does not work in a page header or footer in SSRS 2008 R2 if the value expression uses the Global!PageNumber variable Q2563216 KB2563216 January 26, 2021
2562971 FIX: "The SQL Server Analysis Services <SSAS Name> service terminated unexpectedly" error when a query uses the MDSCHEMA_MEMBERS rowset and a [MEMBER_NAME] restriction in SSAS 2008 R2 Q2562971 KB2562971 January 26, 2021
2562812 FIX: Error code 17065 when you trace a stored procedure that contains a TVP if the TVP contains a large amount of text or of image data in SQL Server 2008 or in SQL Server 2008 R2 Q2562812 KB2562812 January 26, 2021
2562753 FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 or in SSAS 2012 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension Q2562753 KB2562753 January 26, 2021
2561690 FIX: Data collector collects query statistics slowly in SQL Server 2008 R2 if the database server has many connections Q2561690 KB2561690 January 26, 2021
2554905 FIX: "File error: Data may have been lost" error message when you use Excel 2010 to open an Excel report file that was exported from SSRS 2008, from SSRS 2008 R2 or from SSRS 2012 Q2554905 KB2554905 January 26, 2021
2550552 FIX: SQL Server command stops responding when it uses a nonbuffered access path to access a FILESTREAM file in SQL Server 2008 R2 or SQL Server 2008 Q2550552 KB2550552 January 26, 2021
2550375 FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 or in SQL Server 2012 when you run log shipping from many databases to one secondary server Q2550375 KB2550375 January 26, 2021
2547017 FIX: Instances of DAX functions that have no names incorrectly appear when you add a calculated member to a report that uses an SSAS 2008 R2 database as a data source Q2547017 KB2547017 January 26, 2021
2546715 FIX: Non-convergence when a custom stored procedure propagates data changes for a transactional replication in SQL Server 2008 or in SQL Server 2008 R2 Q2546715 KB2546715 January 26, 2021
2545989 FIX: "A time-out occurred while waiting for buffer latch" error when many transactions concurrently update a database in SQL Server 2008 R2 or in SQL Server 2008 if the database uses the snapshot isolation level Q2545989 KB2545989 January 26, 2021
2544983 FIX: "'Databaseproperty' is not a recognized built-in function name" error when you replicate a SQL Server 2008 or a SQL Server 2008 R2 transactional publication in SQL Server "Denali" Q2544983 KB2544983 January 26, 2021
2543687 FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2 Q2543687 KB2543687 January 26, 2021
2542225 FIX: Assertion failure or other issues occur when you run a DML query against a table or view that has two indexes in SQL Server 2008 or in SQL Server 2008 R2 Q2542225 KB2542225 January 26, 2021
2539378 FIX: Replmerg.exe crashes when it enumerates changes to a statement in SQL Server if the stored procedure contains more than 4,000 characters Q2539378 KB2539378 January 26, 2021
2539098 FIX: "Runtime error: the property DBPROP_MSMD_UPDATE_ISOLATION_LEVEL cannot be found" error when an application tries to create a connection to SSAS 2008 R2 Q2539098 KB2539098 January 26, 2021
2537467 FIX: You cannot use SQL Server Management Objects (SMO) to transfer data from a table in SQL Server 2008 or in SQL Server 2008 R2 Q2537467 KB2537467 January 26, 2021
2536225 FIX: CLR stored procedure returns NULL after it is recompiled in SQL Server 2008 R2 or in SQL Server 2008 Q2536225 KB2536225 January 26, 2021
2535705 FIX: An access violation occurs when you restore a database and run the sp_replcounters stored procedure at the same time on a server that is running SQL Server 2008 or SQL Server 2008 R2 Q2535705 KB2535705 January 26, 2021
2532079 FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2 Q2532079 KB2532079 January 26, 2021
2531482 FIX: The IntelliSense feature in SSMS 2008 R2 may stop working after you install Visual Studio 2010 SP1 Q2531482 KB2531482 January 26, 2021
2530921 FIX: Incorrect results when you run an INSERT SELECT UNION ALL statement in SQL Server 2008 or in SQL Server 2008 R2 Q2530921 KB2530921 January 26, 2021
2530913 FIX: "Error: 17066" occurs when you create a partitioned nonclustered index in SQL Server 2008 R2 if a parallel execution plan is used Q2530913 KB2530913 January 26, 2021
2526959 FIX: Application performance issue when a query references temporary tables that are created in a session in SQL Server 2008 and in SQL Server 2008 R2 Q2526959 KB2526959 January 26, 2021
2526552 FIX: SQL Server Browser service periodically does not respond to incoming requests Q2526552 KB2526552 January 26, 2021
2525665 FIX: SQL Server 2008 BIDS stops responding when you stop debugging a SSIS 2008 or a SSIS 2008 R2 package Q2525665 KB2525665 January 26, 2021
2525273 FIX: A clustering model that uses the K-means algorithm generates different results that are affected by PredictOnly columns in SQL Server 2008 R2 Analysis Services Q2525273 KB2525273 January 26, 2021
2525165 FIX: Error message "ORA-01722: invalid number" when you replicate a table to an Oracle server subscriber in SQL Server 2008 or in SQL Server 2008 R2 if a varchar (max) column of the table contains a long value record Q2525165 KB2525165 January 26, 2021
2524743 FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or in a SQL Server 2008 R2 environment Q2524743 KB2524743 January 26, 2021
2522893 FIX: A backup operation on a SQL Server 2008 or SQL Server 2008 R2 database fails if you enable change tracking on this database Q2522893 KB2522893 January 26, 2021
2522708 FIX: Performance decreases after you move a report that contains a large multi-select drop-down parameter list to SQL Server 2008 R2 Reporting Services Q2522708 KB2522708 January 26, 2021
2521127 FIX: PowerPivot window does not open when you open an .xla or .xlam file in Excel 2010 if PowerPivot for Excel 2010 is installed Q2521127 KB2521127 January 26, 2021
2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used Q2520808 KB2520808 January 26, 2021
2520240 FIX: Permission error when you view a folder by using the "ViewMode=WebpartList" parameter in the query string for Report Manager in SQL Server 2008 R2 Reporting Services Q2520240 KB2520240 January 26, 2021
2519638 FIX: Error 6512 when you run the sp_addsubscription stored procedure if the "@sync_type" parameter is set to "replication support only" in SQL Server 2008 or in SQL Server 2008 R2 Q2519638 KB2519638 January 26, 2021
2519358 FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008 or in SQL Server 2008 R2 Q2519358 KB2519358 January 26, 2021
2518876 FIX: MDX query incorrectly returns NULL or 0 values for some measures if a calculated member is used on the row axis in SSAS 2008 R2 Q2518876 KB2518876 January 26, 2021
2518808 FIX: "Expression: (pCopySrc - command) <= (int) cmdLength" error when you add a column to a table published in a transactional publication in SQL Server 2008 R2 Q2518808 KB2518808 January 26, 2021
2518306 FIX: MDX query returns incorrect results in SSAS 2008, in SSAS 2008 R2, or in SSAS 2012 if the data cache is not populated Q2518306 KB2518306 January 26, 2021
2516439 FIX: "The script '/MDM/ScriptResource.axd' contains multiple calls to Sys.Application.notifyScriptLoaded(). Only one is allowed" error on a SQL Server 2008 R2 MDS website Q2516439 KB2516439 January 26, 2021
2516163 FIX: Report builder 3.0 stops responding after you run a query more than two times against a report model in SSRS 2008 R2 Q2516163 KB2516163 January 26, 2021
2515489 FIX: "Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION" and SQL Server 2008 R2 crashes when you start a SQL Server Extended event session Q2515489 KB2515489 January 26, 2021
2515286 FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2515286 KB2515286 January 26, 2021
2515006 FIX: A report displays incorrect results if you use a filtered shared dataset in a SQL Server 2008 R2 report Q2515006 KB2515006 January 26, 2021
2511963 FIX: Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session Q2511963 KB2511963 January 26, 2021
2511151 FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005, SSIS 2008 or in SSIS 2008 R2 Q2511151 KB2511151 January 26, 2021
2506795 FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services environment Q2506795 KB2506795 January 26, 2021
2506235 FIX: An access violation may occur when a database is enabled for Transparent Database Encryption in SQL Server 2008 or in SQL Server 2008 R2 Q2506235 KB2506235 January 26, 2021
2505256 FIX: Poor performance when worktables that are marked for deferred drop are cleaned up in SQL Server 2008 R2 Q2505256 KB2505256 January 26, 2021
2504112 FIX: Performance issue in entity member creation when business rule validation is in progress in SQL Server 2008 R2 MDS Q2504112 KB2504112 January 26, 2021
2504090 FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2504090 KB2504090 January 26, 2021
2503834 FIX: Assertion error when you try to recover a database in SQL Server 2008 R2 Q2503834 KB2503834 January 26, 2021
2499023 FIX: Incorrect results when a complex update query uses the JOIN operator in an execution plan in SQL Server 2008 or in SQL Server 2008 R2 Q2499023 KB2499023 January 26, 2021
2498818 FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Q2498818 KB2498818 January 26, 2021
2498796 FIX: An access violation may occur when you update the statistics of a table after you enable and then disable conflict detection on a table in in SQL Server 2008 or in SQL Server 2008 R2 Q2498796 KB2498796 January 26, 2021
2497575 FIX: "Error: 18210, Severity: 16, State: 1" error when an application tries to use VDI to back up some data in a SQL Server 2008 or SQL Server 2008 R2 instance Q2497575 KB2497575 January 26, 2021
2497301 FIX: "Validate Version" page takes a long time to appear or times out after you click "Validate version" on the SQL Server 2008 R2 MDS website Q2497301 KB2497301 January 26, 2021
2496375 FIX: "Could not open global shared memory to communicate with performance DLL" warning when you run an SSIS 2008 or SSIS 2008 R2 package on a computer that is running Windows XP Q2496375 KB2496375 January 26, 2021
2494517 FIX: A hidden text box value that is referenced in the Tablix header is displayed only on the first page when you export a report to any hard page-break rendering format in SQL Server 2008 R2 Reporting Services Q2494517 KB2494517 January 26, 2021
2493229 FIX: Unexpected null values may appear when you import or refresh data in a PowerPivot for Excel 2010 workbook that was published on a SharePoint site Q2493229 KB2493229 January 26, 2021
2492931 FIX: SSRS 2008 R2 crashes when you use SSRS 2008 R2 to render the enhanced metafile (.emf) format or print many reports at the same time Q2492931 KB2492931 January 26, 2021
2492381 FIX: SQL Server 2008 R2 performs poorly when most threads wait for the CMEMTHREAD wait type if the threads use table variables or temp tables to load or update rowsets Q2492381 KB2492381 January 26, 2021
2491510 FIX:A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008 or SQL Server 2008 R2 Q2491510 KB2491510 January 26, 2021
2491210 FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008 or in SQL Server 2008 R2 Q2491210 KB2491210 January 26, 2021
2490555 FIX: Data update does not occur daily in SQL Server 2008 R2 PowerPivot for SharePoint if business hours are set to end the next day Q2490555 KB2490555 January 26, 2021
2489667 FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2489667 KB2489667 January 26, 2021
2484392 FIX: "xact_seqno" column in the "MSrepl_errors" table does not record a skipped row in SQL Server 2008 or in SQL Server 2008 R2 if you use the "-SkipErrors" parameter in the Distribution Agent Q2484392 KB2484392 January 26, 2021
2482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string Q2482977 KB2482977 January 26, 2021
2481274 FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2481274 KB2481274 January 26, 2021
2478514 FIX: "The merge process could not access row data" error occurs when the Merge Agent stops, and rows are set to 4 in the genstatus column in the msmerge_genhistory system table Q2478514 KB2478514 January 26, 2021
2476322 FIX: A common table expression-based query that uses the CHANGETABLE function runs very slowly in SQL Server 2008 Service Pack 1 or SQL Server 2008 R2 Q2476322 KB2476322 January 26, 2021
2463682 FIX: Database with transparent data encryption enabled is marked as "suspect" if the server certificate is dropped in SQL Server 2008 or in SQL Server 2008 R2 Q2463682 KB2463682 January 26, 2021
2459027 FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008 Q2459027 KB2459027 January 26, 2021
2455614 FIX: BIDS for SQL Server 2008 or SQL Server 2008 R2 responds very slowly when you design an MDX query that has many query parameters Q2455614 KB2455614 January 26, 2021
2451688 FIX: "CPerIndexMetaQS::ErrorAbort - Index corruption" error when you try to update a partitioned view in SQL Server 2008 R2 Q2451688 KB2451688 January 26, 2021
2451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2 Q2451540 KB2451540 January 26, 2021
2448971 FIX: The locks of a table are not escalated when you insert many rows into a table in SQL Server 2008 or in SQL Server 2008 R2 Q2448971 KB2448971 January 26, 2021
2445812 FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2445812 KB2445812 January 26, 2021
2445751 FIX: "An error occurred during this operation" error when you try to print a report from a SharePoint Server 2010 website in Internet Explorer 8 Q2445751 KB2445751 January 26, 2021
2444085 FIX: "Transaction is already aborted (WinMgmt)" error when you run DTC transactions from BizTalk Server 2009 to SQL Server 2008 or SQL Server 2008 R2 if event notifications are enabled Q2444085 KB2444085 January 26, 2021
2435844 FIX: A SQL Server Agent job incorrectly runs after the specified end date in SQL Server 2008 and in SQL Server 2008 R2 Q2435844 KB2435844 January 26, 2021
2435404 FIX: Computer stops responding when you create a database that contains a FILESTREAM filegroup in SQL Server 2008 or in SQL Server 2008 R2 if a third-party mini-filter driver is installed Q2435404 KB2435404 January 26, 2021
2433265 FIX: You may receive an incorrect result when you run a query that uses the ROW_NUMBER function together with a left outer join in SQL Server 2008 and SQL Server 2008 R2 Q2433265 KB2433265 January 26, 2021
2432235 FIX: High memory consumption may occur when you rebuild a single partition of the heap table in SQL Server 2008 or SQL Server 2008 R2 Q2432235 KB2432235 January 26, 2021
2431362 FIX: Error message when you try to create a named query in a project that uses SQL Server 2008 R2 Parallel Data Warehouse as a data source: "Keyword not supported" Q2431362 KB2431362 January 26, 2021
2428916 FIX: A performance condition alert is incorrectly raised in SQL Server 2008 or SQL Server 2008 R2 if a case-sensitive collation is configured Q2428916 KB2428916 January 26, 2021
2428397 FIX: "Type mismatch" error message occurs when you try to delete an embedded PowerPivot database from an instance of SQL Server 2008 R2 Analysis Services that is installed in the SharePoint Integration mode Q2428397 KB2428397 January 26, 2021
2428310 FIX: Inconsistent results when you run a complex query that uses the APPLY operator in SQL Server 2008 R2 Q2428310 KB2428310 January 26, 2021
2421014 FIX: "A severe error occurred on the current command" error message when you use the Freetexttable or the Containstable function on an indexed view in a CTE query in SQL Server 2008 or in SQL Server 2008 R2 Q2421014 KB2421014 January 26, 2021
2413430 FIX: "Cannot locate version record and page is not allocated" error message occurs when you rebuild an index by using the ONLINE option in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2413430 KB2413430 January 26, 2021
2412136 FIX: The Entities Explorer grid displays few rows in a SQL Server 2008 R2 MDS website if you use a low screen resolution Q2412136 KB2412136 January 26, 2021
2410425 FIX: You receive an exception when you try to create an MDS database in SQL Server 2008 R2 MDS if a non-MDS database table is named "tblSystem" Q2410425 KB2410425 January 26, 2021
2407088 FIX: "Sys.ArgumentNullException" error occurs when you open a drillthrough report in a Report Viewer Web part if you use the SharePoint Integrated mode in SQL Server 2008 R2 Reporting Services Q2407088 KB2407088 January 26, 2021
2406666 FIX: "[Teradata Database] [3737]" error when you click "Count" in the Aggregation Design Wizard in SSAS 2008, in SSAS 2012 or in SSAS 2008 R2 Q2406666 KB2406666 January 26, 2021
2404865 FIX: High CPU usage when you run a SQL Server Agent job in SQL Server 2008 or SQL Server 2008 R2 if a column of a dynamic SELECT statement has a value that is many characters long Q2404865 KB2404865 January 26, 2021
2403218 FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used Q2403218 KB2403218 January 26, 2021
2401453 FIX: "Search failed: Failed to retrieve data for this request" message when you search for some SQL Azure database objects in the "Object Explorer Details" tab of SQL Server 2008 R2 Management Studio Q2401453 KB2401453 January 26, 2021
2397020 FIX: "Access is denied. [0x80070005]" error message occurs in SSCM when you try to change the password of an account of SQL Server 2008 or SQL Server 2008 R2 in Windows Vista or in a later version of Windows Q2397020 KB2397020 January 26, 2021
2387686 FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008 or SQL Server 2008 R2 Q2387686 KB2387686 January 26, 2021
2384766 FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008 or in SQL Server 2008 R2 Q2384766 KB2384766 January 26, 2021
2380435 FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2380435 KB2380435 January 26, 2021
2380361 FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 or in SQL Server 2008 R2 if the table contains a nondeterministic computed column Q2380361 KB2380361 January 26, 2021
2379466 FIX: "0x84B10001" error code, SQL Server 2008 or SQL Server 2008 R2 Setup failure, and an unhandled exception occur when you run SQL Server 2008 or SQL Server 2008 R2 Setup Q2379466 KB2379466 January 26, 2021
2359606 FIX: "System.OverflowException: Value was either too large or too small for an Int32" error message occurs when you try to generate a report in Microsoft SQL Server 2008 R2 Reporting Services Q2359606 KB2359606 January 26, 2021
2357947 FIX: Incorrect order of the characters and numbers when you use OLE DB Provider for DB2 version 3.0 if the column contains some Hebrew characters Q2357947 KB2357947 January 26, 2021
2352413 FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008 or SQL Server 2008 R2 Q2352413 KB2352413 January 26, 2021
2344694 FIX: Certain change tracking functions and DMVs do not work correctly after an automatic database mirroring failover occurs in SQL Server 2008 R2 or in SQL Server 2008 Q2344694 KB2344694 January 26, 2021
2344600 FIX: "Non-yielding Scheduler" error may occur when you use the CONTAINSTABLE function together with many OR and AND predicates in SQL Server 2008 or in SQL Server 2008 R2 Q2344600 KB2344600 January 26, 2021
2315727 FIX: You cannot create, add, or edit steps for an SQL Server Agent job in SQL Server Management Studio 2008 R2 Q2315727 KB2315727 January 26, 2021
2306162 FIX: Poor performance and some occasional non-yielding scheduler errors occur when you create a complex view that references a large amount of nested views or tables in SQL Server 2008 or in SQL Server 2008 R2 Q2306162 KB2306162 January 26, 2021
2300689 FIX: You cannot restore a backup of a database on another instance of SQL Server if you disable transparent data encryption before you create the backup in SQL Server 2008 or in SQL Server 2008 R2 Q2300689 KB2300689 January 26, 2021
2297903 FIX: Event ID 322 is logged when a server audit is output in SQL Server 2008 or SQL Server 2008 R2 Q2297903 KB2297903 January 26, 2021
2297709 FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server Q2297709 KB2297709 January 26, 2021
2297308 FIX: "A previous filestream configuration attempt was incomplete" error and an access violation occur when you perform post-setup configuration of the FILESTREAM feature on a SQL Server 2008 or SQL Server 2008 R2 failover cluster Q2297308 KB2297308 January 26, 2021
2295878 FIX: LOB pages that are allocated in a failed INSERT statement may not be reclaimed after you apply SQL Server 2005 SP3, SQL Server 2005 SP4, SQL Server 2008 SP1 or SQL Server 2008 R2 Q2295878 KB2295878 January 26, 2021
2295869 FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005, SQL Server 2008, or in SQL Server 2008 R2 Q2295869 KB2295869 January 26, 2021
2295460 Fix: Replication error message when you register a custom resolver to a merge replication in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 if a BIGINT column contains a NULL value Q2295460 KB2295460 January 26, 2021
2291551 FIX: Error occurs when you try to configure a remote report server database by using Reporting Services Configuration Manager in the Datacenter edition of SQL Server 2008 R2 Reporting Services Q2291551 KB2291551 January 26, 2021
2290377 FIX: The Report Definition Customization Extension does not modify the RDL file as expected in SQL Server 2008 R2 Q2290377 KB2290377 January 26, 2021
2287990 FIX: The "Derived Column" transformation may produce incorrect results when you run a package in Microsoft SQL Server 2008 or SQL Server 2008 R2 Integration Services Q2287990 KB2287990 January 26, 2021
2285720 FIX: A fix is available for SQL Server Management Studio 2008 R2 that enables you to rename SQL Azure databases in Object Explorer Q2285720 KB2285720 January 26, 2021
2285711 FIX: A fix is available that improves the manageability of SSMS 2008 R2 to support Spatial Types for SQL Azure Q2285711 KB2285711 January 26, 2021
2285517 FIX: "HTTP 503: Service unavailable" error message when you execute a report in SQL Server 2008 R2 Q2285517 KB2285517 January 26, 2021
2284503 FIX: You encounter two issues when you use Microsoft SQL Server 2008 R2 Master Data Services (MDS) Q2284503 KB2284503 January 26, 2021
2283186 FIX: "Requested value 'Unknown' was not found" error message when you update a parameter for a SQL Server 2008 R2 report in SharePoint Server 2010 Q2283186 KB2283186 January 26, 2021
2283091 FIX: BIDS crashes when you use the Map Layer wizard to add sptial data in SQL Server 2008 R2 Reporting Services Q2283091 KB2283091 January 26, 2021
2283072 FIX: A hotfix is available that enables SQL Server 2008 Reporting Services and SQL Server 2008 R2 Reporting Services to use a 2048-bit RSA key to encrypt a Reporting Services key for FIPS compliancy Q2283072 KB2283072 January 26, 2021
2283051 FIX: "The item '/å¾®è½¯ä¸¬å½' cannot be found. (rsItemNotFound)" error message when you click the Folder Settings button in Microsoft SQL Server 2008 R2 Reporting Services Q2283051 KB2283051 January 26, 2021
2283036 FIX: Forms-based authentication does not work in SQL Server 2008 R2 Reporting Services Q2283036 KB2283036 January 26, 2021
2280390 FIX: Error message when you query an XML data type column in an SQL table on a server that is running SQL Server 2008 or SQL Server 2008 R2: "Index was outside the bounds of the array" Q2280390 KB2280390 January 26, 2021
2278042 FIX: A derived column transformation may generate incorrect results in SSIS 2008 or in SSIS 2008 R2 when a column is derived both in read-only usage and in read/write usage Q2278042 KB2278042 January 26, 2021
2277078 FIX: The TokenAndPermUserStore cache store size continues to grow when you enable a SQL Server audit in SQL Server 2008 R2 and in SQL Server 2008 Q2277078 KB2277078 January 26, 2021
2276717 FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008 and in Microsoft SQL Server 2008 R2 Q2276717 KB2276717 January 26, 2021
2276330 FIX: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2 Q2276330 KB2276330 January 26, 2021
2276203 FIX: It takes a long time to open a SQL Server 2008 R2 Reporting Services report that contains many parameter values in Internet Explorer Q2276203 KB2276203 January 26, 2021
2269585 FIX: SharePoint services and SharePoint Server Enterprise Site Collection features are disabled after you uninstall the PowerPivot for SharePoint component on a computer that is running SQL Server 2008 R2 Q2269585 KB2269585 January 26, 2021
2268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2268122 KB2268122 January 26, 2021
2261403 FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q2261403 KB2261403 January 26, 2021
2256829 FIX: A certain number of the last XML columns may not be replicated correctly if you use web synchronization for merge replication in SQL Server 2008 or SQL Server 2008 R2 Q2256829 KB2256829 January 26, 2021
2225696 FIX: You cannot import a data table from SQL Server by using PowerPivot in Excel 2010 Q2225696 KB2225696 January 26, 2021
2214666 FIX: An SSIS package that uses the Unpivot transformation may produce inconsistent results in SQL Server 2008 or SQL Server 2008 R2 Q2214666 KB2214666 January 26, 2021
2163980 FIX: The SQL Server service cannot start after you install cumulative update package 1 for SQL Server 2008 R2 if a UCP exists in the instance of SQL Server Q2163980 KB2163980 January 26, 2021
2159286 FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer Q2159286 KB2159286 January 26, 2021
2142496 FIX: A SQL Server 2008 R2 or SQL Server 2008 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table Q2142496 KB2142496 January 26, 2021
983286 FIX: "A connection cannot be made" error message in SSAS 2008 or SSAS 2008 R2 when you try to connect to a database Q983286 KB983286 January 26, 2021
982854 FIX: Error "There is insufficient system memory in resource pool 'internal' to run this query" in Microsoft SQL Server Q982854 KB982854 January 26, 2021
982441 FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008 or SQL Server 2008 R2 Q982441 KB982441 January 26, 2021
982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q982376 KB982376 January 26, 2021
981611 FIX: An access violation occurs when you use the COUNT_BIG function and the OVER clause in a query in SQL Server 2008 or SQL Server 2008 R2 Q981611 KB981611 January 26, 2021
980849 FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q980849 KB980849 January 26, 2021
980832 FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q980832 KB980832 January 26, 2021
980142 FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services Q980142 KB980142 January 26, 2021
979785 FIX: Error message when you use the Script Wizard to generate scripts for stored procedures in SQL Server 2008 or SQL Server 2008 R2 Q979785 KB979785 January 26, 2021
979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication Q979212 KB979212 January 26, 2021
978629 FIX: Error message when you use the system_health Extended Event session to capture a deadlock graph in SQL Server 2008: "Msg 9436: XML parsing: line 54, character 12, end tag does not match start tag" Q978629 KB978629 January 26, 2021
975752 FIX: "ConnConnectAndSetCryptoForXpstar failed (0)"error message occurs when you try to start the SQL Server Agent service from a Remote Desktop session in SQL Server 2008 or in SQL Server 2008 R2 Q975752 KB975752 January 26, 2021
969845 FIX: Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]" Q969845 KB969845 January 26, 2021
968215 FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008 or in SQL Server 2008 R2: "Bulk load data conversion error" Q968215 KB968215 January 26, 2021
963659 FIX: You receive error messages when you perform a population for a large full-text index in SQL Server 2008 or in SQL Server 2008 R2 Q963659 KB963659 January 26, 2021
960770 FIX: You receive error 605 and error 824 when you run a query that inserts data into a temporary table in SQL Server Q960770 KB960770 January 26, 2021
942712 FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Q942712 KB942712 January 26, 2021
922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q922578 KB922578 January 26, 2021
3137281 FIX: Communication that uses an MD5 hash algorithm fails when you use TLS 1.2 in SQL Server Q3137281 KB3137281 January 25, 2021
2957174 FIX: Cannot create compressed nonclustered index on a table that has a clustered index with two or more bit columns Q2957174 KB2957174 January 25, 2021
2911663 FIX: SQL Server does not clean up the missing index entries until the corresponding queries are executed in SQL Server 2008 R2 Q2911663 KB2911663 January 25, 2021
2830722 FIX: Access violation when you use a SQL profiler to trace an RPC event class in SQL Server 2008 or SQL Server 2008 R2 Q2830722 KB2830722 January 25, 2021
2216489 FIX: Error message when you try to run an SSIS package that contains a SQL Server Destination component in a Dataflow task Q2216489 KB2216489 January 25, 2021
2546901 FIX: Results may change every time that you run a parallel query in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2 if the query uses a ranking function and if the computer has eight or more CPUs Q2546901 KB2546901 January 13, 2021
2292807 FIX: "USE statement is not supported to switch between databases" error message when you run a custom report in SQL Server 2008 R2 Management Studio Q2292807 KB2292807 January 13, 2021
2597229 FIX: Report Builder 3.0 stops responding if SSRS 2008 R2 uses forms authentication Q2597229 KB2597229 May 20, 2020
4539036 Frequently asked questions about ESU for Windows Server and SQL Server 2008 and 2008 R2 Q4539036 KB4539036 February 4, 2020
941105 FIX: Error messages after SQL Server has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process" Q941105 KB941105 November 20, 2019
2700227 FIX: Error message when you try to create a data service document in a data feed library from a sub-site collection in SharePoint 2010 to publish Atom feeds: "There is no file with URL" Q2700227 KB2700227 September 25, 2018
2518716 FIX: Script for an object of a SQL Azure database is not generated when you use SSMS 2008 R2 to connect to SQL Azure Q2518716 KB2518716 September 24, 2018
2270925 FIX: PowerPivot workbooks are always loaded to the PowerPivot server that is last added to the SharePoint farm despite the use of server health based allocation or round-robin allocation Q2270925 KB2270925 September 20, 2018
2509659 FIX: The dbo schema is preappended when you use a custom stored procedure in the sp_addarticle stored procedure Q2509659 KB2509659 September 19, 2018
2282505 FIX: Business Intelligence Development Studio 2008 R2 does not generate an RDL.DATA file when you preview a SQL Server report Q2282505 KB2282505 September 18, 2018
955828 FIX: Error message when you try to enable FILESTREAM settings in SQL Server 2008 or in SQL Server 2008 R2: “There was an unknown error applying the FILESTREAM settings” Q955828 KB955828 April 21, 2018
2793580 FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server Q2793580 KB2793580 January 19, 2015
2973961 FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server Q2973961 KB2973961 November 17, 2014
2967103 FIX: Service broker stops working when you unregister and remove a session in SQL Server Q2967103 KB2967103 October 21, 2014
2723979 FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server Q2723979 KB2723979 October 9, 2014
2963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions Q2963668 KB2963668 September 30, 2014
2920987 FIX: Poor performance when many table-valued parameters are used in SQL Server Q2920987 KB2920987 September 30, 2014
2888996 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 Q2888996 KB2888996 September 30, 2014
2952260 FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server Q2952260 KB2952260 September 15, 2014
2862883 FIX: SQL Server performance issues in NUMA environments Q2862883 KB2862883 September 11, 2014
2922526 FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscription Q2922526 KB2922526 June 30, 2014
2936154 FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server Q2936154 KB2936154 June 27, 2014
2559662 FIX: Slow performance when you render a report that returns a long string of text in SSRS 2008 R2 if the text contains no carriage return characters Q2559662 KB2559662 June 21, 2014
981973 FIX: The data in a custom report item is displayed incorrectly after you export the report to a PDF format file by using the ReportExecutionService.Render method in SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services Q981973 KB981973 June 21, 2014
2458438 FIX: SQL Server 2008 R2 Analysis Services introduces new trace events to track resource usage and locks by using SQL Server Profiler Q2458438 KB2458438 June 5, 2014
2567304 FIX: Text is truncated from the DTExec.exe output log file when WshShell.Exec is called if the StdOut stream is redirected Q2567304 KB2567304 May 19, 2014
2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2605597 KB2605597 May 15, 2014
2555235 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2555235 KB2555235 May 15, 2014
2911385 FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server Q2911385 KB2911385 April 25, 2014
2913206 FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS by using HTML forms Q2913206 KB2913206 April 21, 2014
2904010 FIX: A small number of rows are sampled in SQL Server when table statistics are updated automatically or together with specified sampling rate Q2904010 KB2904010 April 21, 2014
2891489 FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server Q2891489 KB2891489 April 21, 2014
2891230 FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS Q2891230 KB2891230 April 21, 2014
2890095 FIX: Interrupted distributed query may return partial result set without any error in SQL Server Q2890095 KB2890095 April 21, 2014
2885565 FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server Q2885565 KB2885565 April 21, 2014
2878377 FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server Q2878377 KB2878377 April 21, 2014
2868348 FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS Q2868348 KB2868348 April 21, 2014
2864930 FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server Q2864930 KB2864930 April 21, 2014
2652738 FIX: "File system error" error when you process a large dimension Q2652738 KB2652738 September 25, 2013
2811842 FIX: Missing parameter panel of a drillthrough report when a top-level report contains hidden parameters or no parameters in SSRS 2008 R2 or SSRS 2012 Q2811842 KB2811842 August 23, 2013
2837247 FIX: W3WP.exe process stops unexpectedly when multiple merge replication subscribers synchronize at the same time in SQL Server 2008 R2 or SQL Server 2012 Q2837247 KB2837247 August 21, 2013
2760981 FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable Q2760981 KB2760981 April 15, 2013
972936 FIX: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION." error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q972936 KB972936 February 18, 2013
2431178 FIX: Error message and the report is not printed from the Report Manager website in SSRS 2008 or SQL Server 2008 R2 if you use Internet Explorer Protected Mode in Internet Explorer 8 Q2431178 KB2431178 February 2, 2013
2739213 FIX: Error message when you render an SSRS report that uses the rc:Toolbar=false parameter in the URL: "An error occurred within the report server database" Q2739213 KB2739213 January 24, 2013
2757344 FIX: Business Intelligence Development Studio (BIDS) crashes when you select a WSDL file in SQL Server 2008 R2 Q2757344 KB2757344 December 17, 2012
2708027 FIX: "An error has occurred during report processing" error message when you try to preview an SSRS 2008 R2 or SSRS 2012 report after you set the dataset collation to Greek or Greek_100 Q2708027 KB2708027 November 20, 2012
2707185 FIX: An MDX query in SQL Server 2008 R2 runs very slowly if the query contains nested Crossjoin functions Q2707185 KB2707185 October 15, 2012
2707015 FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2 or in SSRS 2012 Q2707015 KB2707015 August 29, 2012
979778 FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008 Q979778 KB979778 August 27, 2012
2737869 FIX: SQL Server StreamInsight 1.2 installation fails or StreamInsight application does not run if FIPS is enabled Q2737869 KB2737869 August 14, 2012
2735237 "File System Error" error when you refresh a PowerPivot workbook on a SharePoint site Q2735237 KB2735237 July 25, 2012
2498839 FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 or in SSAS 2008 Q2498839 KB2498839 July 16, 2012
2295244 FIX: You are still prompted to install an RSClientPrint control in SSRS 2008 or SSRS 2008 R2 Q2295244 KB2295244 July 5, 2012
2672888 FIX: Basic attribute hierarchy settings are lost if you reopen a role in a SSAS 2008 R2 project in BIDS Q2672888 KB2672888 June 25, 2012
2706518 FIX: The KeepFilesForDays setting does not work in SQL Server 2008 or SQL Server 2008 R2 Reporting Services Q2706518 KB2706518 June 18, 2012
2504524 FIX: "Bad variable type" or "Type mismatch" error when you run an UPDATE CUBE statement that has a custom weighted allocation formula in SSAS 2008 R2 or in SSAS 2008 Q2504524 KB2504524 May 21, 2012
2638932 FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2 Q2638932 KB2638932 April 17, 2012
2661225 FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer Q2661225 KB2661225 April 12, 2012
2655789 FIX: Replication Log Reader Agent fails with "18773" and "18805" error messages if you set the 'large value types out of row' table option to ON for the publication article table Q2655789 KB2655789 April 12, 2012
2652582 FIX: "Invalid authorization specification" error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode Q2652582 KB2652582 April 12, 2012
2647120 FIX: Incorrect page numbers are displayed when you export a SSRS 2008 R2 report into PDF format Q2647120 KB2647120 April 12, 2012
2622668 FIX: Error message when you delete some records in a table on a publisher if the schema name of the table is not "[dbo]" Q2622668 KB2622668 April 12, 2012
2137539 FULL or BULK recovery models can provide better data protection and recovery Q2137539 KB2137539 April 2, 2012
2253635 FIX: MDX queries experience slow performance when a new SSAS role user connects to the SSAS database in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2253635 KB2253635 March 28, 2012
2675518 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 Q2675518 KB2675518 March 12, 2012
2675230 FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators Q2675230 KB2675230 February 22, 2012
2675226 FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators Q2675226 KB2675226 February 22, 2012
2644260 FIX: A main report is re-rendered when you click a link to view a drillthrough report in SSRS 2008 R2 Q2644260 KB2644260 February 22, 2012
2624915 FIX: Part of a report is not displayed when you use the Report Viewer Web Part on a SharePoint 2010 site to view a SSRS 2008 R2 report Q2624915 KB2624915 February 22, 2012
2531172 FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2531172 KB2531172 January 17, 2012
2643340 FIX: Action property does not work when you view an SSRS 2008 R2 report in Report Manager Q2643340 KB2643340 January 6, 2012
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
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
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
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
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
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
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
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
2506799 FIX: Performance decreases after you move a large report to SQL Server 2008 R2 Reporting Services Q2506799 KB2506799 April 18, 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
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
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
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
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
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
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
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

SQL Server 2008 R2 articles, fixes and updates - letter F