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
955626 Error message when you try to run the Sqlmaint Utility after you upgrade to SQL Server 2008 or a later version: "The SQLDMO 'Application' object failed to initialize"
955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure
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
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
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
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
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
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
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