Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Products
  3. SQL Server 2008 R2 Workgroup

Articles for product: SQL Server 2008 R2 Workgroup

Article ID Article Title Hidden
2152734 How to troubleshoot SQL Server database consistency errors
2154845 Recommendations to reduce allocation contention in SQL Server tempdb database
2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language
2407439 You may notice an increased transaction log sizes in SQL Server 2008 and later versions when you perform Index Maintenance
2416767 You may get an error message when trying to load or save a SSIS package
2443455 You may experience connectivity issues if SQL Server service account delegation settings are misconfigured
2443457 You may experience connectivity issues to SQL Server if SPNs are misconfigured
2449398 Error message when you try to install SQL Server 2008 R2
2454053 Use of system filter drivers can lead to SQL Server Database Engine performance degradation and consistency problems
2483962 [SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2
2496344 SQL Server Installation Center may display English content on a localized version of SQL Server after you apply a cumulative update
2508239 An AFTER INSERT trigger may not work correctly after you apply the fix documented in 975950
2520691 Updating a view via Linked server query may fail
2621109 [SDP 3][a9a06d82-6a20-424a-b9ac-3f36236d4f5a] SQL Server Setup data-collection diagnostic tool
2632388 SQL NUMA Node IDs reported in SQL Errorlog may not match hardware NUMA node IDs
2650553 Error message in SQL Server 2008 Replication Monitor: "An error occurred while retrieving the publication data"
2656988 How to enable the CHECKSUM option if backup utilities do not expose the option
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2750005 Merge replication does not support centralized subscriber topologies
2754171 Controlling Autostat (AUTO_UPDATE_STATISTICS) behavior in SQL Server
2773194 [SDP 3] [155888db-ad84-4e39-a4e1-f6e6c3b185b4] Information that is collected by SQL RS Diagnostics Collector
2787112 "Msg 8992" error message and inconsistent metadata in the SQL Server system catalogs
2795690 SQL Server agent crashes when you try to start it or takes longer than expected to start
2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level
2861775 0x80040E21 or 0x80004005 error when a data flow task in an SSIS package runs an MDX query by using MSOLAP in SQL Server
2871695 [SDP 3][ab09ed03-7576-425f-aae0-8f36c0e8c662] Information that is collected by the SQL Server Connectivity Diagnostics Collector
2874903 "System.OutOfMemoryException" exception when you execute a query in SQL Server Management Studio
2892633 How to troubleshoot merge replication performance issues by using trace flag 101
2892635 "20011" error messages in SQL Server when the Replication Log Reader Agent fails
2938136 "Could not find stored procedure sp_server_diagnostics" error and the instances of SQL Server 2008 R2 or SQL Server 2008 cannot fail over in a SQL Server 2012 cluster environment
2962968 You canot install SQL Server 2008 R2 by using a service account when only an RODC is reachable
2965553 Decreased performance for SQL Server when you run a TOP, MAX or MIN aggregating clause on columns other than the partitioning column
2967651 INF: SQL Server may display memory corruption and recovery errors
2974455 DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume
2977319 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (QFE): August 12, 2014
2977320 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (GDR): August 12, 2014
2984340 MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014
2985455 Kerberos Configuration Manager for SQL Server is available
3049257 Error 3989 or 3988 when a distributed query that joins multiple tables is hosted by remote instances of SQL Server
3053639 SQL Server query that typecasts a Unicode column to a binary collation returns incorrect results
3083381 Duplicate key rows from the sys.syscommittab table in SQL Server
3144525 Performance decreases when you run a SELECT ..INTO query after you upgrade to SQL Server 2012 and later
3163368 Max_Queue_Readers property is ignored when you try to limit activation tasks in Service Broker
3195161 Defragmenting SQL Server database disk drives
3196535 Description of the Update Cache folder in SQL Server
4023373 Event ID 17141 is logged when SQL Server does not come online in Windows Failover Clustering