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 Enterprise X64 Edition

Article ID Article Title Hidden
937517 FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction"
937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database
937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error"
937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections
939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"
939537 Cumulative update package 3 for SQL Server 2005 Service Pack 2
942177 How to determine the version of SQL Server 2005 Integration Services
948109 MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
950636 FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system
953568 FIX: The synchronization operation of a merge replication times out in Microsoft SQL Server 2005
954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
967095 The Windows Internal Database (WYukon) is removed when you use the Add or Remove Programs item in Control Panel to uninstall a security update for SQL Server 2005
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
970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009
2009160 High CPU use occurs when you run queries in SQL Server
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
2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language
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
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
2450864 PRB:You are not able to change the default location for Full-Text Catalogs
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
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
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
2656988 How to enable the CHECKSUM option if backup utilities do not expose the option
2664701 Support in SQL Server for custom COM-based conflict resolvers that handle merge replication
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2750005 Merge replication does not support centralized subscriber topologies
2753868 Enabling pre_creation_command option requires re-initialization