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.

Articles for product: SQL Server 2008 R2 Developer

Article ID Article Title Hidden
2423467 How to create a trace log that helps troubleshoot MDS database creation issues
2423478 How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services
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
2470176 Applications may fail after upgrading your database from SQL Server 2000 to a later version
2483962 [SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2
2490051 Mirrored databases are disconnected after you restart the database mirror in SQL Server 2005, SQL Server 2008, or SQL 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
2519834 SQL Server reports "Operating system error 1117 (I/O Device Error)" on VMware ESX environments that are configured to use PVSCSI adapters
2520691 Updating a view via Linked server query may fail
2523164 SQL Server configuration changes may not be installed because they have not been reconfigured or SQL Server has not been restarted
2523744 The transaction log may grow without a log backup for a database using the FULL recovery model
2539091 You should not disable the guest user in the msdb database in SQL Server
2547273 You cannot add or remove features to a SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 failover cluster
2549443 Improve the performance of full-text queries in SQL Server
2600089 Use of virtual host drivers can lead to SQL Server Database Engine data consistency problems
2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient
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
2664701 Support in SQL Server for custom COM-based conflict resolvers that handle merge replication
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector
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
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
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
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
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