SQL Server 2005 articles, fixes and updates - letter H

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 starts with letter H that have been released. The list is daily updated.

• 2656988 How to enable the CHECKSUM option if backup utilities do not expose the option Q2656988 KB2656988 January 25, 2021
• 953199 How to configure and troubleshoot the SubscriptionStreams parameter of the Distribution Agent in SQL Server 2005 and above Q953199 KB953199 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 913089 How to obtain the latest service pack for SQL Server 2005 Q913089 KB913089 January 25, 2021
• 906560 How to write information to the Application event log by using a Script task in a SQL Server 2005 Integration Services package Q906560 KB906560 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 307356 How to understand Merge Replication article processing order Q307356 KB307356 January 25, 2021
• 306397 How to use Excel with SQL Server linked servers and distributed queries Q306397 KB306397 January 25, 2021
• 75722 How to reduce lock contention in SQL Server Q75722 KB75722 January 14, 2021
• 930615 How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005 Q930615 KB930615 January 7, 2021
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
• 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server Q914288 KB914288 November 8, 2020
• 139444 How to remove duplicate rows from a table in SQL Server Q139444 KB139444 November 8, 2020
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
• 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
• 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
• 240872 How to resolve permission issues when you move a database between servers that are running SQL Server Q240872 KB240872 September 29, 2020
• 906547 How to create a dynamic subject or message for the Send Mail task in SQL Server 2005 Integration Services Q906547 KB906547 September 3, 2020
• 909801 How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005 Q909801 KB909801 August 20, 2020
• 243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions Q243589 KB243589 May 31, 2020
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
• 198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 April 30, 2020
• 909967 How to manually uninstall an instance of SQL Server 2005 Q909967 KB909967 April 10, 2020
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 12, 2019
• 914278 How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing Q914278 KB914278 November 20, 2019
• 914277 How to configure SQL Server 2005 to allow remote connections Q914277 KB914277 November 20, 2019
• 908360 How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions Q908360 KB908360 November 20, 2019
• 823938 How to configure SQL Server to listen on a specific port Q823938 KB823938 November 20, 2019
• 294453 How to set up SQL Server to listen on multiple static TCP ports Q294453 KB294453 November 20, 2019
• 265808 How to connect to SQL Server by using an earlier version of SQL Server Q265808 KB265808 November 20, 2019
• 918483 How to reduce paging of buffer pool memory in SQL Server Q918483 KB918483 November 15, 2019
• 958998 How to troubleshoot IIS configuration issues in SQL Server 2005 Reporting Services Q958998 KB958998 October 16, 2019
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 April 4, 2019
• 2019698 How to schedule and automate backups of SQL Server databases in SQL Server Express Q2019698 KB2019698 February 18, 2019
• 2015741 How to troubleshoot Error 3414 and a failed database recovery with SQL Server Q2015741 KB2015741 August 29, 2018
• 956600 How to use the SubscriptionStreams parameter of Distribution Agent to test for improved disk subsystem throughput in SQL Server 2005 and above Q956600 KB956600 August 9, 2018
• 2015748 How to troubleshoot database consistency errors reported by DBCC CHECKB Q2015748 KB2015748 July 2, 2018
• 932376 How to configure SharePoint Server 2007 to use a database that is hosted on a server that is running SQL Server in an untrusted domain Q932376 KB932376 April 23, 2018
• 243899 How to access additional information about errors that are returned when you use the OLE Automation system stored procedures Q243899 KB243899 April 21, 2018
• 953740 How to identify and enable disabled SQL Server instances in SQL Server 2000 Q953740 KB953740 April 20, 2018
• 934653 How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package Q934653 KB934653 April 20, 2018
• 920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 April 20, 2018
• 913967 How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005 Q913967 KB913967 April 20, 2018
• 912911 How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step Q912911 KB912911 April 20, 2018
• 908460 How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data Flow task Q908460 KB908460 April 20, 2018
• 908018 How to create a package template in SQL Server Business Intelligence Development Studio Q908018 KB908018 April 20, 2018
• 906566 How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 Q906566 KB906566 April 20, 2018
• 325335 How to transfer a database from one collation to another collation in SQL Server Q325335 KB325335 April 20, 2018
• 324401 How to manually remove a replication in SQL Server 2000 or in SQL Server 2005 Q324401 KB324401 April 20, 2018
• 321247 How to configure security for SQL Server log shipping Q321247 KB321247 April 20, 2018
• 319942 How to determine proper SQL Server configuration settings Q319942 KB319942 April 20, 2018
• 318605 How SQL Server uses a certificate when the Force Protocol Encryption option is turned on Q318605 KB318605 April 20, 2018
• 315521 How to troubleshoot SQL Server merge replication problems Q315521 KB315521 April 20, 2018
• 313295 How to use the server name parameter in a connection string to specify the client network library Q313295 KB313295 April 20, 2018
• 309256 How to troubleshoot SQL Server error 8645 Q309256 KB309256 April 20, 2018
• 306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server Q306212 KB306212 April 20, 2018
• 303722 How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Server Q303722 KB303722 April 20, 2018
• 300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 April 20, 2018
• 295732 How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed Q295732 KB295732 April 20, 2018
• 288809 How to recover SQL Server after a tempdb database is marked suspect Q288809 KB288809 April 20, 2018
• 288577 How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server Q288577 KB288577 April 20, 2018
• 246800 How to correctly parse quotation marks in Full Text Search queries Q246800 KB246800 April 20, 2018
• 243588 How to troubleshoot the performance of Ad-Hoc queries in SQL Server Q243588 KB243588 April 20, 2018
• 199037 How to capture error messages that are sent to clients from an instance of SQL Server Q199037 KB199037 April 20, 2018
• 175574 How to rotate a table in SQL Server Q175574 KB175574 April 20, 2018
• 137983 How to troubleshoot orphaned connections in SQL Server Q137983 KB137983 April 20, 2018
• 70956 How to remove duplicate rows from a SQL Server table by using a script Q70956 KB70956 April 20, 2018
• 69133 How to convert CHAR values into DATETIME values in SQL Server Q69133 KB69133 April 20, 2018
• 938245 How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 Q938245 KB938245 April 19, 2018
• 919157 How to display a report that contains a subreport by using the ReportViewer control in Visual Studio 2005 Q919157 KB919157 April 19, 2018
• 319930 How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition Q319930 KB319930 April 19, 2018
• 283811 How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL Server 2005 Q283811 KB283811 April 19, 2018
• 271509 How to monitor blocking in SQL Server 2005 and in SQL Server 2000 Q271509 KB271509 April 19, 2018
• 169377 How to access SQL Server in Active Server Pages Q169377 KB169377 April 19, 2018
• 926824 How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring Q926824 KB926824 April 18, 2018
• 937682 How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism Q937682 KB937682 April 17, 2018
• 919160 How to enable the snapshot transaction isolation level in SQL Server 2005 Analysis Services Q919160 KB919160 April 17, 2018
• 909953 How to uninstall SQL Server Management Studio Q909953 KB909953 April 17, 2018
• 323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 April 17, 2018
• 322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition Q322336 KB322336 April 17, 2018
• 314520 How to pass a variable to a linked server query Q314520 KB314520 April 17, 2018
• 246133 How to transfer logins and passwords between instances of SQL Server that are running older versions of SQL Server Q246133 KB246133 April 17, 2018
• 274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 April 16, 2018
• 959823 How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3 Q959823 KB959823 April 13, 2018
• 933837 How to make an MDX query return a value in the numeric format in SQL Server 2005 Analysis Services Q933837 KB933837 April 13, 2018
• 932881 How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult Q932881 KB932881 April 13, 2018
• 922670 How to use the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL Server 2005 Q922670 KB922670 April 13, 2018
• 919711 How to configure SQL Server 2005 Analysis Services to generate memory dump files Q919711 KB919711 April 13, 2018
• 917407 How to upgrade or downgrade an assembly that has a referenced assembly for a CLR object in an instance of SQL Server 2005 Q917407 KB917407 April 13, 2018
• 917040 How to use the timestamp column of a table for optimistic concurrency control in SQL Server 2005 Q917040 KB917040 April 13, 2018
• 814576 How to consolidate physical files and rename the logical file name in SQL Server 2000 and in SQL Server 2005 Q814576 KB814576 April 13, 2018
• 810056 How to manually re-create the resource-specific registry keys for SQL Server cluster resources Q810056 KB810056 April 13, 2018
• 2015100 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q2015100 KB2015100 February 14, 2018
• 2015756 How to troubleshoot Msg 824 in SQL Server Q2015756 KB2015756 November 28, 2017
• 2015755 How to troubleshoot a Msg 823 error in SQL Server Q2015755 KB2015755 November 28, 2017
• 2015754 How to troubleshoot Error 17204 and 17207 in SQL Server Q2015754 KB2015754 November 28, 2017
• 111401 How to iterate through a result set by using Transact-SQL in SQL Server Q111401 KB111401 October 27, 2017
• 918992 How to transfer logins and passwords between instances of SQL Server Q918992 KB918992 October 9, 2017
• 231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 October 9, 2017
• 321686 How to import data from Excel to SQL Server Q321686 KB321686 April 26, 2017
• 934162 How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows Q934162 KB934162 March 30, 2017
• 917400 How to obtain the SQL Server Runtime license Q917400 KB917400 March 30, 2017
• 912426 How to detect the status of the SQL Server Express service or start the SQL Server Express service by using Visual Basic or Visual C# Q912426 KB912426 March 30, 2017
• 907511 How to shrink the transaction log file in SQL Server 2005 Q907511 KB907511 March 30, 2017
• 906562 How to use the dtutil utility (Dtutil.exe) to set the protection level of a batch of SQL Server Integration Services (SSIS) packages in SQL Server 2005 Q906562 KB906562 March 30, 2017
• 875447 How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page Q875447 KB875447 March 30, 2017
• 298475 How to troubleshoot SQL Server performance issues Q298475 KB298475 January 16, 2017
• 319723 How to use Kerberos authentication in SQL Server Q319723 KB319723 January 11, 2017
• 923398 How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Server 2008-based computer Q923398 KB923398 December 9, 2015
• 2914662 How to use PFX-formatted certificates in SQL Server Q2914662 KB2914662 August 31, 2015
• 3066750 How to troubleshoot error 20598 "The row was not found at the Subscriber when applying the replicated command" Q3066750 KB3066750 May 29, 2015
• 327489 How to use the DisallowAdHocAccess setting to control access to linked servers Q327489 KB327489 May 18, 2015
• 321836 How to retrieve a specific table or rows from database backups or transaction log backups in SQL Server Q321836 KB321836 June 22, 2014
• 316005 How to import XML into SQL Server with the XML Bulk Load component Q316005 KB316005 June 22, 2014
• 280106 How to set up and troubleshoot a linked server to an Oracle database in SQL Server Q280106 KB280106 June 22, 2014
• 262499 How to specify output parameters when you use the sp_executesql stored procedure in SQL Server Q262499 KB262499 June 22, 2014
• 244980 How to change the network IP addresses of SQL Server failover cluster instances Q244980 KB244980 June 22, 2014
• 942177 How to determine the version of SQL Server 2005 Integration Services Q942177 KB942177 June 21, 2014
• 907877 How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005 Q907877 KB907877 June 20, 2014
• 196909 How to increase the number of SQL Server error logs Q196909 KB196909 May 9, 2014
• 2015747 How to troubleshoot Msg 5180 in SQL Server Q2015747 KB2015747 May 7, 2014
• 2015739 How to troubleshoot Msg 605 with SQL Server Q2015739 KB2015739 May 7, 2014
• 2199578 How to manage the SQL Server error log Q2199578 KB2199578 May 1, 2014
• 941232 How to apply a hotfix for SQL Server in a replication topology Q941232 KB941232 February 28, 2014
• 2892633 How to troubleshoot merge replication performance issues by using trace flag 101 Q2892633 KB2892633 October 14, 2013
• 968872 How to open the firewall port for SQL Server on Windows Server 2008 Q968872 KB968872 July 12, 2013
• 314546 How to move databases between computers that are running SQL Server Q314546 KB314546 July 12, 2013
• 977051 How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology Q977051 KB977051 January 18, 2013
• 324321 How to troubleshoot error 15401 Q324321 KB324321 November 27, 2012
• 917409 How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication Q917409 KB917409 August 16, 2012
• 2015757 How to troubleshoot Msg 825 (read retry) in SQL Server Q2015757 KB2015757 July 9, 2012
• 186133 How to dynamically number rows in a SELECT Transact-SQL statement Q186133 KB186133 September 17, 2011
• 953504 How to change SQL Server parameters in a clustered environment when SQL Server is not online Q953504 KB953504 May 16, 2011
• 2466860 How to determine and change the port of an SSAS Instance Q2466860 KB2466860 November 19, 2010
• 2406745 How to calculate Previous Period Growth in SQL Server Analysis Services Q2406745 KB2406745 October 20, 2010
• 953200 How to migrate SQL Server 2005 Service Pack 2 failover clustered instances from Windows Server 2003 Service Pack 2 to Windows Server 2008 Q953200 KB953200 September 11, 2010
• 2015357 Huge blocking in SQL Server that is used with Configuration Manager 2007 Server Q2015357 KB2015357 July 8, 2010
• 2015760 How to troubleshoot Msg 7105 in SQL Server Q2015760 KB2015760 April 1, 2010
• 2015759 How to troubleshoot Msg 832 (constant page has changed) in SQL Server Q2015759 KB2015759 April 1, 2010
• 2015753 How to troubleshoot Error 9004 in SQL Server Q2015753 KB2015753 April 1, 2010
• 263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 September 15, 2009
• 910230 How to install SQL Server 2005 Analysis Services on a failover cluster Q910230 KB910230 August 14, 2009
• 969200 How to return uniqueidentifier initialized with NEWSEQUENTIALID() function to the .Net client Q969200 KB969200 March 18, 2009
• 931975 How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 Q931975 KB931975 July 10, 2008
• 314783 How to plan SQL Server CE, SQL Server 2005 Compact Edition, or SQL Server 2005 Mobile Edition security for mobile devices in IIS and SQL Server 2000 Windows CE Edition Q314783 KB314783 July 3, 2008
• 934164 How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer Q934164 KB934164 June 13, 2008
• 952114 How the impersonation information option of a SQL Server 2005 Analysis Services database affects deployment and synchronization Q952114 KB952114 May 14, 2008
• 941151 How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 Q941151 KB941151 May 1, 2008
• 917446 How to install SharePoint Portal Server 2003 Service Pack 2 and Windows SharePoint Services Service Pack 2 in a deployment that uses SQL Server 2005 as the database back end Q917446 KB917446 April 28, 2008
• 325877 How to control access to a database on a Web server in Windows Server 2003 Q325877 KB325877 December 3, 2007
• 936492 How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically Q936492 KB936492 November 20, 2007
• 928907 How to improve concurrency in a SQL Server 2005 application by using built-in functions Q928907 KB928907 November 20, 2007
• 827968 How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database Q827968 KB827968 November 20, 2007
• 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
• 814130 How to help secure network connectivity for SQL Server 2000 local databases Q814130 KB814130 October 29, 2007
• 841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
• 912914 How to use a stored procedure to monitor traces in SQL Server 2005 Q912914 KB912914 September 4, 2007
• 934163 How to upgrade SQL Server 2005 Reporting Services on a Windows Vista-based computer Q934163 KB934163 June 22, 2007
• 915852 How to use certificates for SQL Server 2005 Service Broker remote security on multiple instances of SQL Server 2005 Q915852 KB915852 May 31, 2007
• 912907 How to specify the location of a temporary database in SQL Server 2005 Compact Edition Q912907 KB912907 May 3, 2007
• 933032 How to hide a dimension name when no members are visible for a security role in SQL Server 2005 Analysis Services Q933032 KB933032 April 3, 2007
• 287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
• 162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
• 813731 How to retrieve data from a SQL Server CE 2.0 database or from a SQL Server 2005 Compact Edition database and save the data in an XML document Q813731 KB813731 December 7, 2006
• 253817 How to back up the last transaction log when the master and the database files are damaged in SQL Server Q253817 KB253817 September 11, 2006
• 918481 How to install Microsoft Operations Manager (MOM) 2005 Service Pack 1 databases and MOM 2005 Reporting on a computer that has Microsoft SQL Server 2005 installed Q918481 KB918481 August 4, 2006
• 233332 How to run the SQLdiag utility on a clustered instance of SQL Server or on virtual SQL Server Q233332 KB233332 June 9, 2006
• 841251 How to enable SQL Server connectivity on Windows XP Service Pack 2 Q841251 KB841251 April 18, 2006
• 915856 How to set a default member of a dimension to a calculated member in SQL Server 2005 Analysis Services Q915856 KB915856 April 14, 2006
• 842425 How to move a Reporting Services database from a computer that is running Reporting Services to another computer Q842425 KB842425 April 7, 2006
• 290624 How to configure MSDTC in a Windows 2000 cluster environment Q290624 KB290624 April 7, 2006
• 916784 How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services Q916784 KB916784 April 3, 2006
• 319716 How to populate a SQL Server 2005 database by using information from Active Directory Q319716 KB319716 March 21, 2006
• 906564 How to use SQL Server Business Intelligence Development Studio or the dtutil utility to regenerate the package ID of an SSIS package that was duplicated Q906564 KB906564 March 11, 2006
• 906563 How to interpret data that is logged by using a SQL Server 2005 Integration Services log provider Q906563 KB906563 March 11, 2006
• 907716 How to obtain SQL Server Management Studio Express (SSMSE) community technology preview (CTP) Q907716 KB907716 January 31, 2006
• 911839 How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management Q911839 KB911839 January 23, 2006
• 839980 How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2 Q839980 KB839980 January 11, 2006
• 308737 How to identify the cause of recompilation in an SP:Recompile event Q308737 KB308737 December 23, 2005
• 248915 How to show expanding hierarchies by using SQL Server Q248915 KB248915 December 20, 2005
• 911838 How to measure the rate at which rows pass through a particular data flow task in a SQL Server 2005 Integration Services (SSIS) package Q911838 KB911838 December 16, 2005
• 298568 How to rebuild the master database on a virtual SQL Server instance Q298568 KB298568 December 10, 2005
• 115519 How to use the Findstr tool to scan SQL error log files or DBCC output files for analyzing errors Q115519 KB115519 November 23, 2005
• 243428 How to move extended stored procedures out of process Q243428 KB243428 November 3, 2004