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 Enterprise

Articles for product: SQL Server 2008 R2 Enterprise

Article ID Article Title Hidden
2668489 TFS data corruption with SQL Server 2008 & 2008 R2 Enterprise
2674882 "Error 1205" when you configure transactional replication in SQL Server 2005 or SQL Server 2008
2676768 Recommended updates when you use data compression and table partitions
2678763 When the Filestream feature is enabled in SQL Server 2008, you receive a Stop error, and the computer restarts unexpectedly
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2688307 Event ID 17659 and event ID 3859 are logged when you update system tables in a SQL Server database
2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector
2700641 SQL Server Assertion error when you try to execute a Bulk Insert or BCP statement: "<loglock.cpp>, line=807 Failed Assertion = 'result == LCK_OK' "
2722715 Support for the leap second
2727217 Distribution Agent reports the transactional replication latency incorrectly in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012
2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server
2732669 Recommendations and guidelines on dynamically extending SQL Server disk volumes
2733512 Supported method for reducing the SQL Server 2008 R2 setup media size
2750005 Merge replication does not support centralized subscriber topologies
2753868 Enabling pre_creation_command option requires re-initialization
2754171 Controlling Autostat (AUTO_UPDATE_STATISTICS) behavior in SQL Server
2755960 SQL query performance might decrease when the SQL Server Database instance has high index fragmentation
2773194 [SDP 3] [155888db-ad84-4e39-a4e1-f6e6c3b185b4] Information that is collected by SQL RS Diagnostics Collector
2782589 "Msg 6602" error when you execute the sp_xml_preparedocument stored procedure in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012
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
2796944 Crash occurs when you call Automation procedures from CLR Objects in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012
2799534 Various problems may occur when running SQL Server 2012 in Hyper-V or VMWare environment
2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level
2832689 "Cannot find the identity range allocation entry for the Subscriber" error when you add an article to a SQL Server merge publication
2853715 You cannot run the SSIS package in 64-bit mode in SQL Server 2008 R2 or SQL Server 2008
2860895 SQL Server is not supported on a Windows operating system on which case sensitivity is enabled
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
2882905 A 9017 informational message is logged when you start an instance of SQL Server or restore or attach a database
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
2900760 SQLDescribeCol returns the wrong column length and data type in a complex union query that has parameters
2913774 An index build takes a long time when a SQL Server database backup is running
2914662 How to use PFX-formatted certificates in SQL Server
2923956 "34052" error message and PBM generates alerts on policies that have an evaluation mode in SQL Server
2926557 SQL Server VDI backup and restore operations require Sysadmin privileges
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
2966940 INFO: Extended Events Histogram target may show unexpected results
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
2979636 SQL Server generates a 3023 message when backup and file operations are tried at the same time
2984340 MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014
2985455 Kerberos Configuration Manager for SQL Server is available
3001293 Error 0xC0202009 occurs when SSIS does a parameter cast in SQL Server