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 Developer Edition

Article ID Article Title Hidden
977051 How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010
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
2157198 32-bit SQL Server failover clustering is not supported on 64-bit versions of Windows
2199578 How to manage the SQL Server error log
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
2481773 You get "Error code 64" when accessing Replisapi.dll through ISA server
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
2539091 You should not disable the guest user in the msdb database in SQL Server
2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient
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
2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector
2722715 Support for the leap second
2750005 Merge replication does not support centralized subscriber topologies
2753868 Enabling pre_creation_command option requires re-initialization
2755960 SQL query performance might decrease when the SQL Server Database instance has high index fragmentation
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
2799534 Various problems may occur when running SQL Server 2012 in Hyper-V or VMWare environment
2801413 Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level
2860895 SQL Server is not supported on a Windows operating system on which case sensitivity is enabled
2861775 0x80040E21 or 0x80004005 error when a data flow task in an SSIS package runs an MDX query by using MSOLAP in SQL Server