SQL Server 2008 R2 articles, fixes and updates - January 2021

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

• 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
• 3033860 An on-demand hotfix update package is available for SQL Server 2008 R2 SP3 Q3033860 KB3033860 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
• 3005011 Unexpected growth of tempdb data files when using SQL Server Service Broker Q3005011 KB3005011 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
• 2987585 Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012 Q2987585 KB2987585 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
• 2967540 Cumulative update package 13 for SQL Server 2008 R2 SP2 Q2967540 KB2967540 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
• 2966940 INFO: Extended Events Histogram target may show unexpected results Q2966940 KB2966940 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
• 2938478 Cumulative Update 12 for SQL Server 2008 R2 SP2 Q2938478 KB2938478 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
• 2926028 Cumulative update package 11 for SQL Server 2008 R2 Service Pack 2 Q2926028 KB2926028 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
• 2908087 Cumulative update package 10 for SQL Server 2008 R2 SP2 Q2908087 KB2908087 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
• 2889492 You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1 Q2889492 KB2889492 January 26, 2021
• 2887606 Cumulative update package 9 for SQL Server 2008 R2 SP2 Q2887606 KB2887606 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
• 2868244 An on-demand hotfix update package is available for SQL Server 2008 R2 SP1 Q2868244 KB2868244 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
• 2855792 Cumulative update package 13 for SQL Server 2008 R2 SP1 Q2855792 KB2855792 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
• 2844090 Cumulative update package 7 for SQL Server 2008 R2 SP2 Q2844090 KB2844090 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
• 2830140 Cumulative update package 6 for SQL Server 2008 R2 SP2 Q2830140 KB2830140 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
• 2828727 Cumulative update package 12 for SQL Server 2008 R2 SP1 Q2828727 KB2828727 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
• 2826162 Different data is returned when you use SharePoint List data extension for a report in SSRS 2008 R2 or SSRS 2012 Q2826162 KB2826162 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
• 2820068 Can't install SQL Server by using InstallShield or bootstrapping application Q2820068 KB2820068 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
• 2813697 "A system assertion check has failed" error message when you execute a CREATE PARTITION FUNCTION statement in SQL Server 2008 R2 Q2813697 KB2813697 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
• 2812683 Cumulative update package 11 for SQL Server 2008 R2 SP1 Q2812683 KB2812683 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
• 2797460 Cumulative update package 5 for SQL Server 2008 R2 SP2 Q2797460 KB2797460 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
• 2792921 Description of new features in SQL Server 2012 and SQL Server 2008 R2 SP2 Q2792921 KB2792921 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
• 2777358 Cumulative update package 4 for SQL Server 2008 R2 SP2 Q2777358 KB2777358 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
• 2756574 Cumulative update package 9 for SQL Server 2008 R2 Service Pack 1 Q2756574 KB2756574 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
• 2754552 Cumulative update package 3 for SQL Server 2008 R2 SP2 Q2754552 KB2754552 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
• 2740411 Cumulative update package 2 for SQL Server 2008 R2 Service Pack 2 Q2740411 KB2740411 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
• 2733630 The merge agent may fail during merge replication synchronization in SQL Server Q2733630 KB2733630 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
• 2730301 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released Q2730301 KB2730301 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
• 2723743 Cumulative update package 8 for SQL Server 2008 R2 Service Pack 1 Q2723743 KB2723743 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
• 2720425 Cumulative update package 1 for SQL Server 2008 R2 Service Pack 2 Q2720425 KB2720425 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
• 2703282 Cumulative update package 7 for SQL Server 2008 R2 Service Pack 1 Q2703282 KB2703282 January 26, 2021
• 2703280 Cumulative update package 14 for SQL Server 2008 R2 Q2703280 KB2703280 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
• 2679367 Cumulative update package 6 for SQL Server 2008 R2 Service Pack 1 Q2679367 KB2679367 January 26, 2021
• 2679366 Cumulative update package 13 for SQL Server 2008 R2 Q2679366 KB2679366 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
• 2667211 A query may take a long time to run if the query optimizer uses the Top operator in SQL Server 2008 R2 or in SQL Server 2012 Q2667211 KB2667211 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
• 2659694 Cumulative update package 5 for SQL Server 2008 R2 Service Pack 1 Q2659694 KB2659694 January 26, 2021
• 2659692 Cumulative update package 12 for SQL Server 2008 R2 Q2659692 KB2659692 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
• 2639688 Description of Service Pack 1 update to SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010 Q2639688 KB2639688 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
• 2634571 Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option Q2634571 KB2634571 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
• 2633146 Cumulative update package 4 for SQL Server 2008 R2 Service Pack 1 Q2633146 KB2633146 January 26, 2021
• 2630458 List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2 Q2630458 KB2630458 January 26, 2021
• 2630455 List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2 CTP Q2630455 KB2630455 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
• 2599822 Error message when a business logic handler is used in SQL Server: "The merge process could not store conflict information" Q2599822 KB2599822 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
• 2598145 Description of the Access Connectivity Engine 2010 hotfix package (Ace-x-none.msp): April 24, 2012 Q2598145 KB2598145 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
• 2591748 Cumulative update package 3 for SQL Server 2008 R2 Service Pack 1 Q2591748 KB2591748 January 26, 2021
• 2591746 Cumulative update package 10 for SQL Server 2008 R2 Q2591746 KB2591746 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
• 2567714 Cumulative update package 2 for SQL Server 2008 R2 Service Pack 1 Q2567714 KB2567714 January 26, 2021
• 2567713 Cumulative update package 9 for SQL Server 2008 R2 Q2567713 KB2567713 January 26, 2021
• 2567616 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released Q2567616 KB2567616 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
• 2548124 "0x0000007E" Stop error when you run a VSS-based backup application in Windows 7 or in Windows Server 2008 R2 Q2548124 KB2548124 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
• 2544793 Cumulative update package 1 for SQL Server 2008 R2 Service Pack 1 Q2544793 KB2544793 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
• 2543217 Reports and schedules are deleted from the report server database if SQL Server 2008 or SQL Server 2008 R2 Reporting Services cannot communicate with the SharePoint object model Q2543217 KB2543217 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
• 2528583 List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1 Q2528583 KB2528583 January 26, 2021
• 2527041 ARCHIVED: How to obtain the latest service pack for SQL Server 2008 R2 Q2527041 KB2527041 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
• 2510668 You can now use Package Installation Wizard (Dtsinstall.exe) to run the deployment manifest file of an SSIS package when SSIS 2008 or SSIS 2008 R2 is not installed Q2510668 KB2510668 January 26, 2021
• 2507770 Cumulative Update package 7 for SQL Server 2008 R2 Q2507770 KB2507770 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
• 2491214 "Non-yielding Scheduler" error and SQL Server 2008 or SQL Server 2008 R2 stops responding intermittently in Windows Server 2008 or in Windows Server 2008 R2 Q2491214 KB2491214 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
• 2489376 Cumulative Update package 6 for SQL Server 2008 R2 Q2489376 KB2489376 January 26, 2021
• 2487231 "RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2 Q2487231 KB2487231 January 26, 2021
• 2486113 A drop-down list is always displayed instead of a search box when you double-click the value of the filter criteria box for an attribute in Entities Explorer of the SQL Server 2008 R2 MDS website Q2486113 KB2486113 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
• 2463333 List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1 CTP Q2463333 KB2463333 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
• 2412203 "Bulk Insert with another outstanding result set should be run with XACT_ABORT on" error message may occur when you run a DTC or MARS transaction in SQL Server 2008 or SQL Server 2008 R2 Q2412203 KB2412203 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
• 2345451 Cumulative Update package 4 for SQL Server 2008 R2 Q2345451 KB2345451 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
• 2261464 Cumulative Update package 3 for SQL Server 2008 R2 Q2261464 KB2261464 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
• 2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language Q2252955 KB2252955 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
• 2072493 Cumulative Update package 2 for SQL Server 2008 R2 Q2072493 KB2072493 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
• 981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released Q981356 KB981356 January 26, 2021
• 981355 Cumulative Update package 1 for SQL Server 2008 R2 Q981355 KB981355 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
• 980653 SQL Server 2008 R2 CU2, SQL Server 2008 SP1 CU7 and SQL Server 2005 SP3 CU9 introduce trace flag 4136 to disable the "parameter sniffing" process Q980653 KB980653 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
• 970070 Support for Locked Pages on SQL Server Standard Edition (64-bit) systems Q970070 KB970070 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
• 897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations Q897284 KB897284 January 26, 2021
• 826433 SQL Server diagnostics added to detect unreported I/O problems due to stale reads or lost writes Q826433 KB826433 January 26, 2021
• 322385 SQL Server support in a hyper-threaded environment Q322385 KB322385 January 26, 2021
• 3146034 Intermittent service terminations occur after you install any SQL Server 2008 or SQL Server 2008 R2 versions from KB3135244 Q3146034 KB3146034 January 25, 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
• 3065718 MS15-058: Vulnerabilities in SQL Server could allow remote code execution: July 14, 2015 Q3065718 KB3065718 January 25, 2021
• 3045316 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 GDR: July 14, 2015 Q3045316 KB3045316 January 25, 2021
• 3045314 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 QFE: July 14, 2015 Q3045314 KB3045314 January 25, 2021
• 3045313 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 GDR: July 14, 2015 Q3045313 KB3045313 January 25, 2021
• 3045312 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 QFE: July 14, 2015 Q3045312 KB3045312 January 25, 2021
• 3027860 Error 17066 or 17310 during SQL Server startup Q3027860 KB3027860 January 25, 2021
• 2985455 Kerberos Configuration Manager for SQL Server is available Q2985455 KB2985455 January 25, 2021
• 2984340 MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014 Q2984340 KB2984340 January 25, 2021
• 2977320 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (GDR): August 12, 2014 Q2977320 KB2977320 January 25, 2021
• 2977319 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (QFE): August 12, 2014 Q2977319 KB2977319 January 25, 2021
• 2974455 DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume Q2974455 KB2974455 January 25, 2021
• 2962968 You canot install SQL Server 2008 R2 by using a service account when only an RODC is reachable Q2962968 KB2962968 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
• 2926557 SQL Server VDI backup and restore operations require Sysadmin privileges Q2926557 KB2926557 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
• 2882905 A 9017 informational message is logged when you start an instance of SQL Server or restore or attach a database Q2882905 KB2882905 January 25, 2021
• 2869522 The .NET Framework 4.x assemblies are not supported in SQL Server Reporting Services Q2869522 KB2869522 January 25, 2021
• 2860895 SQL Server is not supported on a Windows operating system on which case sensitivity is enabled Q2860895 KB2860895 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
• 2795690 SQL Server agent crashes when you try to start it or takes longer than expected to start Q2795690 KB2795690 January 25, 2021
• 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 January 25, 2021
• 2687741 A hotfix that improves the performance of the "AlwaysOn Availability Group" feature in SQL Server 2012 is available for Windows Server 2008 R2 Q2687741 KB2687741 January 25, 2021
• 2666213 A TDE-enabled database may not recover in SQL Server 2008 or in SQL Server 2008 R2 Q2666213 KB2666213 January 25, 2021
• 2656988 How to enable the CHECKSUM option if backup utilities do not expose the option Q2656988 KB2656988 January 25, 2021
• 2632388 SQL NUMA Node IDs reported in SQL Errorlog may not match hardware NUMA node IDs Q2632388 KB2632388 January 25, 2021
• 2620201 SQL Server uses a service SID to provide service isolation Q2620201 KB2620201 January 25, 2021
• 2547273 You cannot add or remove features to a SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 failover cluster Q2547273 KB2547273 January 25, 2021
• 2543893 MS11-049: Vulnerability in the Microsoft XML Editor could allow information disclosure: June 14, 2011 Q2543893 KB2543893 January 25, 2021
• 2523744 The transaction log may grow without a log backup for a database using the FULL recovery model Q2523744 KB2523744 January 25, 2021
• 2509302 A database transaction log continues to grow after you upgrade to SQL Server 2012, SQL Server 2008 R2 SP1, SQL Server 2008 SP2 or SQL Server 2008 SP3 Q2509302 KB2509302 January 25, 2021
• 2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011 Q2494088 KB2494088 January 25, 2021
• 2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011 Q2494086 KB2494086 January 25, 2021
• 2438347 Cumulative Update package 5 for SQL Server 2008 R2 Q2438347 KB2438347 January 25, 2021
• 2423478 How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services Q2423478 KB2423478 January 25, 2021
• 2407439 You may notice an increased transaction log sizes in SQL Server 2008 and later versions when you perform Index Maintenance Q2407439 KB2407439 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
• 2199576 How to troubleshoot SQL Server lock related problems and errors Q2199576 KB2199576 January 25, 2021
• 2160685 Recommendations and guidelines for setting the AUTO_CLOSE database option in SQL Server Q2160685 KB2160685 January 25, 2021
• 2160663 Recommendations and guidelines for setting the AUTO_SHRINK database option in SQL Server Q2160663 KB2160663 January 25, 2021
• 2160002 Recommendations and guidelines for improving SQL Server FILESTREAM performance Q2160002 KB2160002 January 25, 2021
• 2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files Q2028436 KB2028436 January 25, 2021
• 2027550 Recommended MSDTC settings for using Distributed Transactions in SQL Server Q2027550 KB2027550 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 923247 Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions Q923247 KB923247 January 25, 2021
• 920093 Tuning options for SQL Server when running in high performance workloads Q920093 KB920093 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 310834 Description of common causes of SQL Server error message 844 or error message 845 Q310834 KB310834 January 25, 2021
• 309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 307356 How to understand Merge Replication article processing order Q307356 KB307356 January 25, 2021
• 234656 Information about using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 January 25, 2021
• 200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries Q200043 KB200043 January 25, 2021
• 86903 Description of caching disk controllers in SQL Server Q86903 KB86903 January 25, 2021
• 4342844 Information about the latest SQL Server 2008 and SQL Server 2008 R2 builds Q4342844 KB4342844 January 20, 2021
• 2681175 DBCC CHECKDB reports a 2576 error after you drop a BLOB column in SQL Server 2008 or in SQL Server 2008 R2 Q2681175 KB2681175 January 20, 2021
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 January 20, 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