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 Datacenter

Articles for product: SQL Server 2008 R2 Datacenter

Article ID Article Title Hidden
2028589 SQL Server reports errors for exceptions, assertions, and hang conditions
2028697 Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server
2028712 Understanding Password Policy for SQL Server Logins.
2029023 Guidelines on Securing folders for Database Files and Program Files of a SQL Server Installation
2032911 You may encounter problems when installing SQL Server on a domain controller
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2033448 Winsock Layered Service Providers (LSP) may result in network or server stability problems for SQL Server
2033523 Separate database and transaction log files on different drives for optimal performance and disaster recovery
2033590 SQL Server records the date/time of the most recent database consistency check with no errors
2078345 ​The database PAGE_VERIFY CHECKSUM option can help detect database consistency problems with the system I/O path
2091024 SQL Server reports Msg 5144 and 5145 for long or failed autogrow of databases and transaction log files
2091098 ​Windows System Event Log Errors that indicate possible I/O problems can be associated with database inconsistency or performance problems for SQL Server
2137408 SQL Server logs "Msg 833" when I/O delay problems occur
2152734 How to troubleshoot SQL Server database consistency errors
2154845 Recommendations to reduce allocation contention in SQL Server tempdb database
2157114 The 'affinity mask' and 'affinity I/O mask' configuration should not conflict
2157129 Changing the 'max worker threads' configuration of SQL Server
2157154 The 'Blocked Process Threshold' configuration does not work as expected for values less than 5
2216456 SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services
2270849 Error 0x80040e97 occurs when you use integrated full-text search in SQL Server
2280126 SQL Server 2008 full-text query may return false positives using number with more than 9 digits as search predicate condition
2292737 Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled
2310152 Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server
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
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
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
2585240 SQL Server stored procedure custom conflict resolver adds "0x00" to conflicting columns
2585632 Synchronization for SQL Server merge replication fails when an article uses a stored procedure custom conflict resolver
2598510 DateTime values are rounded to the nearest second when a business logic handler is used in SQL Server 2008 or SQL Server 2008 R2
2598605 A custom SQL Server business logic handler replaces an empty string with an end-of-string character
2599822 Error message when a business logic handler is used in SQL Server: "The merge process could not store conflict information"
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