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
955850 Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL 'SqlServerSpatial.dll': This application has failed to start because the application configuration is incorrect"
956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"
956139 Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed
956176 Error message when you try to save a table in SQL Server: "Saving changes is not permitted"
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
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.
2028769 FIX: An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery
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
2152472 How to troubleshoot SQL Server Errors that prevent a successful database startup or recovery
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
2160663 Recommendations and guidelines for setting the AUTO_SHRINK database option in SQL Server
2160685 Recommendations and guidelines for setting the AUTO_CLOSE database option in SQL Server
2199576 How to troubleshoot SQL Server lock related problems and errors
2199578 How to manage the SQL Server error log