SQL Server 7.0 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 7.0 starts with letter H that have been released. The list is daily updated.

• 321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 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
• 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
• 139444 How to remove duplicate rows from a table in SQL Server Q139444 KB139444 November 8, 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
• 243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions Q243589 KB243589 May 31, 2020
• 198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 April 30, 2020
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 12, 2019
• 265808 How to connect to SQL Server by using an earlier version of SQL Server Q265808 KB265808 November 20, 2019
• 317604 HOW TO: Configure SQL Server to Store ASP.NET Session State Q317604 KB317604 June 10, 2019
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 April 4, 2019
• 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
• 325335 How to transfer a database from one collation to another collation in SQL Server Q325335 KB325335 April 20, 2018
• 319942 How to determine proper SQL Server configuration settings Q319942 KB319942 April 20, 2018
• 315521 How to troubleshoot SQL Server merge replication problems Q315521 KB315521 April 20, 2018
• 311209 HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management Q311209 KB311209 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
• 300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 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
• 199131 How to add a Visual FoxPro database to SQL Server as a linked server Q199131 KB199131 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
• 829142 How to dynamically page through a large result set in ASP.NET by using SQL Server stored procedures in Visual C# .NET Q829142 KB829142 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
• 312839 How to send e-mail without using SQL Mail in SQL Server Q312839 KB312839 April 19, 2018
• 308157 How To Implement Forms-Based Authentication in Your ASP.NET Application by Using Visual Basic .NET Q308157 KB308157 April 19, 2018
• 169377 How to access SQL Server in Active Server Pages Q169377 KB169377 April 19, 2018
• 323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 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
• 218592 How to perform a SQL Server distributed query with OLAP Server Q218592 KB218592 April 17, 2018
• 203638 How to return information about SQL Server linked servers Q203638 KB203638 April 17, 2018
• 274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 April 16, 2018
• 320141 HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET Q320141 KB320141 April 13, 2018
• 239885 How to change service accounts for a clustered computer that is running SQL Server Q239885 KB239885 April 13, 2018
• 111401 How to iterate through a result set by using Transact-SQL in SQL Server Q111401 KB111401 October 27, 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
• 298475 How to troubleshoot SQL Server performance issues Q298475 KB298475 January 16, 2017
• 327489 How to use the DisallowAdHocAccess setting to control access to linked servers Q327489 KB327489 May 18, 2015
• 313037 How to upgrade SQL Server clusters to Windows Server 2003 Q313037 KB313037 January 17, 2015
• 225545 HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager Q225545 KB225545 January 16, 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
• 319724 HOW TO: Refer to a Just-Inserted Record in a SQL Server 7.0 Q319724 KB319724 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
• 241249 HOW TO: Obtain a List of DTS Packages Q241249 KB241249 June 22, 2014
• 196909 How to increase the number of SQL Server error logs Q196909 KB196909 May 9, 2014
• 842192 How to install SQL Server 7.0 Enterprise Edition on Microsoft Cluster Server Q842192 KB842192 October 26, 2013
• 257868 How To Get the PackageID for Use in the LoadFromRepository Function Q257868 KB257868 October 20, 2013
• 199204 How To Put Stored Procedures Under Remote Source Control in Visual InterDev 6.0 Q199204 KB199204 October 11, 2013
• 314546 How to move databases between computers that are running SQL Server Q314546 KB314546 July 12, 2013
• 324321 How to troubleshoot error 15401 Q324321 KB324321 November 27, 2012
• 301240 How To Implement Forms-Based Authentication in Your ASP.NET Application by Using C#.NET Q301240 KB301240 November 15, 2012
• 186133 How to dynamically number rows in a SELECT Transact-SQL statement Q186133 KB186133 September 17, 2011
• 263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 September 15, 2009
• 254593 How to troubleshoot SQL Cluster Wizard failures Q254593 KB254593 October 14, 2008
• 230590 How to archive more than six SQL Server error logs Q230590 KB230590 July 16, 2008
• 240867 How to move, copy, and back up full-text catalog folders and files Q240867 KB240867 November 30, 2007
• 241397 How to back up a Microsoft Data Engine database by using Transact-SQL Q241397 KB241397 November 14, 2007
• 320499 How to manually synchronize replication subscriptions by using backup or restore Q320499 KB320499 November 12, 2007
• 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
• 841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
• 275474 How To Rebuild an MSMQ Site Controller on a Computer Running MSCS and SQL Server 7.0 Q275474 KB275474 October 26, 2007
• 237458 How To Install an MSMQ Independent Client on a Cluster After SQL Server 7.0 Q237458 KB237458 October 26, 2007
• 224587 HOW TO: Troubleshoot Application Performance with SQL Server Q224587 KB224587 October 26, 2007
• 242929 How to install MSDE by using the Windows Installer Q242929 KB242929 March 19, 2007
• 311021 HOW TO: Manage Quotation Marks in Concatenated SQL Literals by Using ADO.NET and Visual C# .NET Q311021 KB311021 March 9, 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
• 246255 How To Use a SQL Server 7.0 Distributed Query with a Linked Server to Secured Access Databases Q246255 KB246255 February 12, 2007
• 243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
• 301511 How to obtain the latest SQL Server 7.0 service pack Q301511 KB301511 January 29, 2007
• 841823 How to manually enable TCP/IP for SQL Server 7.0 on a computer that is running Windows XP Service Pack 2 Q841823 KB841823 December 12, 2006
• 294349 How To Use ADO and SQL Server to Select Multiple Records by Unique Field Q294349 KB294349 November 23, 2006
• 286320 How To Bind the Office Chart Component to a PivotTable Q286320 KB286320 October 23, 2006
• 323685 HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic Applications Q323685 KB323685 October 16, 2006
• 321525 HOW TO: Use DTS Package Events in Visual Basic .NET Q321525 KB321525 October 16, 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
• 249819 How to pass a timestamp value to or from SQL Server with ODBC API Q249819 KB249819 July 31, 2006
• 276220 HOW TO: Use KEEPFIXED PLAN to Disable Stored Procedure Recompilations Q276220 KB276220 July 19, 2006
• 159976 How To Connect to the Microsoft SQL Server Through the Use of Named Pipes Q159976 KB159976 June 30, 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
• 190987 How to use extended stored procedures Q190987 KB190987 May 9, 2006
• 221193 How to install Data Transformation Services (DTS) Event Handlers in Visual Basic Q221193 KB221193 May 1, 2006
• 841251 How to enable SQL Server connectivity on Windows XP Service Pack 2 Q841251 KB841251 April 18, 2006
• 290624 How to configure MSDTC in a Windows 2000 cluster environment Q290624 KB290624 April 7, 2006
• 270126 How to manage client connectivity to both SQL Server 2000 virtual servers after an Active/Active cluster 7.0 upgrade Q270126 KB270126 March 15, 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
• 295772 How to debug full-text search when a 7608 (0x80004005) error message occurs in SQL Server Q295772 KB295772 January 11, 2006
• 198486 How to use ATL OLE DB Consumer to perform a full-text query with Visual C++ Q198486 KB198486 January 11, 2006
• 321822 HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet Q321822 KB321822 January 10, 2006
• 198485 How to use the Visual C++ ATL Consumer templates to perform a distributed query Q198485 KB198485 January 9, 2006
• 248915 How to show expanding hierarchies by using SQL Server Q248915 KB248915 December 20, 2005
• 240221 HOW TO: Handle Errors in Data Transformation Services "Package" and "Step" Objects Q240221 KB240221 December 20, 2005
• 138541 How to use Odbcping.exe to verify ODBC connectivity to SQL Server Q138541 KB138541 December 7, 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
• 315661 How to run a SQL Server Data Transformation Services package from Visual Basic Q315661 KB315661 August 4, 2005
• 321835 HOW TO: Use sp_OA Stored Procedures and SQL Distributed Management Objects (SQL-DMO) to Script Out Jobs in SQL Server Q321835 KB321835 June 23, 2005
• 241246 HOW TO: List the Results of a SELECT Query on a Table by using SQL-DMO Q241246 KB241246 June 23, 2005
• 241241 How to use DTS with custom ATL OLE-DB providers in Visual C++ 6.0 Q241241 KB241241 June 1, 2005
• 156099 HOW TO: Debug an Extended Stored Procedure Q156099 KB156099 March 14, 2005
• 194522 How to Use ListIndexedColumns in SQL-DMO by Using Visual Basic Q194522 KB194522 March 2, 2005
• 89656 How to calculate the product of a field Q89656 KB89656 February 14, 2005
• 317044 HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C++ .NET Q317044 KB317044 February 7, 2005
• 80397 How to implement password expiration dates for SQL Server 2000 or SQL Server 7.0 login IDs Q80397 KB80397 January 10, 2005
• 243428 How to move extended stored procedures out of process Q243428 KB243428 November 3, 2004
• 320125 How To Move a Database Diagram Q320125 KB320125 July 15, 2004
• 301072 How To Create, Edit, and Execute Stored Procedures in Visual InterDev Q301072 KB301072 July 15, 2004
• 269882 How To Use ADO to Connect to a SQL Server That Is Behind a Firewall Q269882 KB269882 July 15, 2004
• 258038 How To Access and Modify SQL Server BLOB Data by Using the ADO Stream Object Q258038 KB258038 July 15, 2004
• 256282 How To Write a T-SQL Query that Computes and Displays the Percentage of Total Records Aggregated in Each Group of Records Generated by a GROUP BY Clause Q256282 KB256282 July 15, 2004
• 250987 How To Reinstall MS DTC for a Nonclustered Windows NT 4.0 Server Q250987 KB250987 July 15, 2004
• 196652 How To Implement Custom Rounding Procedures Q196652 KB196652 July 15, 2004
• 273953 How to Check the Status of a Commerce Server Direct Mail Campaign Q273953 KB273953 July 13, 2004
• 259492 How To Use DBPROP_SERVERDATAONINSERT to Retrieve the Identity Value of a New Row Q259492 KB259492 July 13, 2004
• 248799 How To Insert NULL Data with ODBC API Functions Q248799 KB248799 July 2, 2004
• 240681 HOWTO: Query Index Server for Custom Properties with SQL Query Analyzer Q240681 KB240681 July 2, 2004
• 260900 How To Insert NULL Data with OLE DB Consumer Templates Q260900 KB260900 July 1, 2004
• 231923 How To Distribute the Microsoft Data Engine (MSDE) With the Package and Deployment Wizard (PDW) Q231923 KB231923 July 1, 2004
• 201785 How To Import FileSystem Data Using DTS and Index Server Q201785 KB201785 July 1, 2004
• 106122 HOW TO: Use the sp_fixindex Stored Procedure Q106122 KB106122 June 24, 2004
• 142584 How to set up SQL Server to listen on Banyan VINES Net-Library Q142584 KB142584 April 15, 2004
• 280102 How to set up a linked server to a Sybase database server and troubleshoot problems that may occur Q280102 KB280102 March 16, 2004
• 241149 HOW TO: Automate Replication over a Dial-Up Connection Q241149 KB241149 February 23, 2004
• 249236 HOW TO: Return Multiple Columns in a DTS Lookup Query Q249236 KB249236 January 14, 2004
• 320728 HOW TO: Resolve "The Maximum Connection Limit Has Been Reached" Error Message Q320728 KB320728 January 12, 2004
• 316043 HOW TO: Log Data Transformation Services Package Execution to a Text File Q316043 KB316043 January 12, 2004
• 216415 HOW TO: Set Up SQL Server with Proxy Server Q216415 KB216415 January 12, 2004
• 239894 How to establish encrypted multiprotocol connections with SQL Server 7.0 Q239894 KB239894 December 30, 2003
• 255599 HOW TO: List Database Properties Settings Q255599 KB255599 December 29, 2003
• 153159 HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server Q153159 KB153159 December 29, 2003
• 320897 HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual C# .NET Q320897 KB320897 December 26, 2003
• 317034 HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual Basic .NET Q317034 KB317034 December 26, 2003
• 314823 HOW TO: Remove a SQL Server Service Pack Q314823 KB314823 December 26, 2003
• 319951 HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services Q319951 KB319951 December 12, 2003
• 219029 HOWTO: Retrieving Calculated Fields from SQL Server 7.0 Q219029 KB219029 December 5, 2003
• 220960 How to Include Other MMCs in SQL Enterprise Manager MMC Q220960 KB220960 November 21, 2003
• 240715 How to Install SQL 7.0 Desktop Edition on SBS 4.5 Clients Q240715 KB240715 November 19, 2003
• 315505 HOW TO: Use the SQL Distributed Management Objects Model to Programmatically Transfer SQL Server Stored Procedures Q315505 KB315505 November 17, 2003
• 220918 HOWTO: Using SQL DMO to Print Date in Regional Format Q220918 KB220918 November 3, 2003
• 255765 HOW TO: Troubleshoot Differences Between An Application and ISQL Q255765 KB255765 September 16, 2003
• 196654 How to Control the SQL Server Services on Windows 95 or Windows 98 Q196654 KB196654 June 11, 2003
• 319663 HOW TO: Remove the IDENTITY Property from an Existing Column in SQL Server 7.0 Q319663 KB319663 October 26, 2002