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
200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries
231347 Description of support for SQL Server databases on compressed volumes
307356 How to understand Merge Replication article processing order
822499 Naming schema and Fix area descriptions for SQL Server software update packages
903643 The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database
907877 How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005
908360 How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions
909967 How to manually uninstall an instance of SQL Server 2005
910378 Scalable shared databases are supported by SQL Server 2005
912262 The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server database instance that hosts the BizTalk Server BizTalkMsgBoxDB database
914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server
918483 How to reduce paging of buffer pool memory in SQL Server
918760 SSIS package does not run when called from a SQL Server Agent job step
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
921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005
921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2
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
925001 FIX: Error message when you run queries between two SQL Server 2005 linked servers: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"
925744 FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"
925976 Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties"
926150 Using database mirroring for cross-database transactions or distributed transactions is not supported in SQL Server
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"
926824 How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
926930 Hard disk drive sector-size support boundaries in SQL Server
927396 Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005
928083 FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005
928323 FIX: A script task or a script component is executed multiple times in duplicate when you run packages that contain script tasks or script components in parallel in SSIS
928518 Error message when you run any of the DBCC CHECK commands in SQL Server: "The database could not be exclusively locked to perform the operation"
929152 You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use "localhost" in the pipe name
929240 FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005
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"
931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has SQL Server 2005 installed
931846 You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components
932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds
932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended
934012 Error message when you try to install SQL Server 2005 on a volume mount point: "There is not enough space on the destination disk for the current SQL Server installation"
934226 FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)"
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
935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk
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
937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure or the sp_OAGetProperty stored procedure to call a method of a COM object in SQL Server 2005
937343 FIX: SQL Server 2005 stops and then restarts unexpectedly, and errors occur in the tempdb database