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
327270 SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server
327489 How to use the DisallowAdHocAccess setting to control access to linked servers
328306 Potential causes of the "SQL Server does not exist or access denied" error message
555332 "Login failed for user" error message when you log on to SQL Server
558119 Event ID 7000 appears in the System log while starting SQL 2005 Server
811889 How to troubleshoot the "Cannot generate SSPI context" error message
814574 Error message when you shrink the transaction log file of a database in SQL Server: "Cannot shrink log file ..."
822101 Description of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005
822400 Description of disaster recovery options for Microsoft SQL Server
822499 Naming schema and Fix area descriptions for SQL Server software update packages
823938 How to configure SQL Server to listen on a specific port
833770 Support for SQL Server on iSCSI technology components
873235 Recover from a full transaction log in a SQL Server database
889615 You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005
897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations
901039 Description of the type mapping of the new SQL Server 2005 data types in Microsoft Data Access Components
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
909967 How to manually uninstall an instance of SQL Server 2005
910708 You must specify the domain groups for the clustered SQL Server services when you install a SQL Server failover cluster
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
915854 You receive an error message when you try to uninstall the second named instance of SQL Server 2005
916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005
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
918760 SSIS package does not run when called from a SQL Server Agent job step
918992 How to transfer logins and passwords between instances of SQL Server
919023 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)
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
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
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
924151 Error message when you run a distributed transaction on a SQL Server 2005-based or SQL Server 2000-based failover cluster: "Resource Manager creation failed: result code = 0x8004d102"
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"
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