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: Microsoft SQL Server 2005 Workgroup Edition

Article ID Article Title Hidden
968749 SQL Server 2005 setup fails if MSXML Core Services 6.0 is installed
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
970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009
971249 Microsoft ODBC drivers can return unexpected results when using parameter markers after any function in a T-SQL Statement
971261 PRB: 'Script table as' reports an error for linked servers created using MSDASQL provider in SQL Server 2005 and SQL Server 2008
2027770 Understanding the .NET Framework requirements for various versions of SQL Server
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
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
2157198 32-bit SQL Server failover clustering is not supported on 64-bit versions of Windows
2416767 You may get an error message when trying to load or save a SSIS package
2443518 Limited support options might be available for certain versions of SQL Server
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
2485757 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4 was released
2489375 Cumulative update package 14 for SQL Server 2005 Service Pack 3
2490051 Mirrored databases are disconnected after you restart the database mirror in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
2507769 Cumulative update package 3 for SQL Server 2005 Service Pack 4
2508239 An AFTER INSERT trigger may not work correctly after you apply the fix documented in 975950
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
2656988 How to enable the CHECKSUM option if backup utilities do not expose the option
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
2750005 Merge replication does not support centralized subscriber topologies
2753868 Enabling pre_creation_command option requires re-initialization
2773194 [SDP 3] [155888db-ad84-4e39-a4e1-f6e6c3b185b4] Information that is collected by SQL RS Diagnostics Collector
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
2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level
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
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
2914662 How to use PFX-formatted certificates in SQL Server
2965553 Decreased performance for SQL Server when you run a TOP, MAX or MIN aggregating clause on columns other than the partitioning column
2967651 INF: SQL Server may display memory corruption and recovery errors
2974455 DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume
2985455 Kerberos Configuration Manager for SQL Server is available