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

Article ID Article Title Hidden
914277 How to configure SQL Server 2005 to allow remote connections
914278 How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing
917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
919155 Error message when you run the DBCC CHECKDB statement on a database that contains one or more very large tables in SQL Server: "Timeout occurred while waiting for latch"
920093 Tuning options for SQL Server when running in high performance workloads
920925 Detours or similar techniques may cause unexpected behaviors with SQL Server
921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2
922672 Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment
922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database
923247 Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions
926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: "Query processor could not produce a query plan because of the hints defined in this query"
930775 FIX: Error message when you try to retrieve rows from a cursor that uses the OPTION (RECOMPILE) query hint in SQL Server 2005: "Could not complete cursor operation because the table schema changed after the cursor was declared"
933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
934396 FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000
935356 Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
936302 List of known issues when you install SQL Server 2005 on Windows Server 2008
936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
939537 Cumulative update package 3 for SQL Server 2005 Service Pack 2
941232 How to apply a hotfix for SQL Server in a replication topology
945934 How to register Microsoft Filter Pack IFilters with SQL Server
948109 MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
955725 Known issues installing SQL Server on Windows 7 or Windows Server 2008 R2
962874 In SQL Server 2005 or 2008, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer
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
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
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
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
2292737 Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled
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