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 Standard

Articles for product: SQL Server 2008 R2 Standard

Article ID Article Title Hidden
956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
958734 SQL Server failover cluster rolling patch and service pack process
967576 Microsoft SQL Server Database Engine Input/Output requirements
968872 How to open the firewall port for SQL Server on Windows Server 2008
969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
969962 Various memory errors are logged to SQL Server error log when using SQL CLR objects
971249 Microsoft ODBC drivers can return unexpected results when using parameter markers after any function in a T-SQL Statement
971268 "Evaluation period has expired" error message when working with SQL server
972387 SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the passive node
977051 How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
980499 English Setup pages are displayed when you run the SQL Server 2008 R2 Setup program for another language
981592 Configuration options are missing on the SharePoint Central Administration Web site
982360 SQL Server 2008 Management Studio functions incorrectly after you install SQL Server 2008 R2 Analysis Services
983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010
2002606 OS errors 1450 and 665 are reported for database data files
2027537 Best Practice recommendations for SQL Server Database Backups
2027550 Recommended MSDTC settings for using Distributed Transactions in SQL Server
2027770 Understanding the .NET Framework requirements for various versions of SQL Server
2028324 How to troubleshoot SQL Server error message 17890
2028433 How to troubleshoot SQL Server error 17112
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
2028443 How to troubleshoot Event ID 12 with source Microsoft-Windows-HAL
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
2152734 How to troubleshoot SQL Server database consistency errors
2154845 Recommendations to reduce allocation contention in SQL Server tempdb database
2199578 How to manage the SQL Server error log
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
2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language
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
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
2425714 Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database
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