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

Article ID Article Title Hidden
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
907511 How to shrink the transaction log file in SQL Server 2005
907877 How to use the DBCC MEMORYSTATUS command to monitor memory usage on 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
917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database
917406 Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005: "The DTS host failed to load or save the package properly"
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
918992 How to transfer logins and passwords between instances of 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
920201 You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server 2008
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
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'"
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"
926930 Hard disk drive sector-size support boundaries in SQL Server
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
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"
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
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
940971 Error message when you try to install a SQL Server 2005 service pack, hotfix, or cumulative update: "The Transaction Manager is not available"
941105 FIX: Error messages after SQL Server has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process"
941232 How to apply a hotfix for SQL Server in a replication topology
942177 How to determine the version of SQL Server 2005 Integration Services
942861 "General Network error", "Communication link failure", or "A transport-level error" message when an application connects to SQL Server
944837 Description of the Replay Markup Language (RML) Utilities for SQL Server
949080 Error message when you execute a CLR routine or use an assembly in SQL Server: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"
949296 Some SQL Server replication agents cannot run when you configure many replication agents to run on a server
951288 SQL Server records a backup operation in the backupset history table when you use VSS to back up files on a volume
953568 FIX: The synchronization operation of a merge replication times out in Microsoft SQL Server 2005
954835 On a computer that has a multicore processor, you may be unable to install SQL Server 2005
955725 Known issues installing SQL Server on Windows 7 or Windows Server 2008 R2
956013 Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"