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

Article ID Article Title Hidden
967576 Microsoft SQL Server Database Engine Input/Output requirements
968749 SQL Server 2005 setup fails if MSXML Core Services 6.0 is installed
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
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
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
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
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
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
2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient
2647989 Error message when you try to create an instance of an OLE DB provider in SQL Server: "Cannot create an instance of OLE DB provider"
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
2674882 "Error 1205" when you configure transactional replication in SQL Server 2005 or SQL Server 2008