SQL Server 2000 articles, fixes and updates

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

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
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
842419 How to grant permissions to a custom assembly that is referenced in a report in Reporting Services Q842419 KB842419 September 29, 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
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
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
953740 How to identify and enable disabled SQL Server instances in SQL Server 2000 Q953740 KB953740 April 20, 2018
920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 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
815154 HOW TO: Configure SQL Server Security for .NET Applications Q815154 KB815154 April 20, 2018
555266 How to pass array of values into SQL Server stored procedure using XML and Visual Basic .NET Q555266 KB555266 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
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
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
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
290991 How to manually remove SQL Server 2000 default, named, or virtual instance Q290991 KB290991 April 19, 2018
290211 How to obtain the latest SQL Server 2000 service pack Q290211 KB290211 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
841549 How to enable ports on Windows XP SP2 for Analysis Services and SQL Server 7.0 OLAP Services Q841549 KB841549 April 17, 2018
555128 HowTo: Backup to UNC name using Database Maintenance Wizard Q555128 KB555128 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
313100 HOW TO: Get Started with Microsoft JDBC Q313100 KB313100 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
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
555017 HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003 Q555017 KB555017 April 13, 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
272067 How To Get a Record Count from a SQL Server CE Recordset Q272067 KB272067 April 13, 2018
239885 How to change service accounts for a clustered computer that is running SQL Server Q239885 KB239885 April 13, 2018
207595 How to do SQL Server 2000 distributed queries with FoxPro .dbf files Q207595 KB207595 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
917400 How to obtain the SQL Server Runtime license Q917400 KB917400 March 30, 2017
890775 How to enable non-sysadmin accounts to execute the "xp_cmdshell" extended stored procedure in SQL Server 2000 Q890775 KB890775 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
327489 How to use the DisallowAdHocAccess setting to control access to linked servers Q327489 KB327489 May 18, 2015
921928 How to configure SQL Server 2000 to use non-uniform memory access (NUMA) Q921928 KB921928 January 17, 2015
918615 How to create a trace by using SQL Profiler in Microsoft SQL Server 2000 to troubleshoot a Microsoft Axapta issue Q918615 KB918615 January 17, 2015
916665 How to cluster SQL Server 2000 Analysis Services on a cluster that is running a 64-bit version of Windows Q916665 KB916665 January 17, 2015
914174 How to build an OLE DB application for SQL Server CE in Visual Studio 2005 Q914174 KB914174 January 17, 2015
903005 HTTP clients stop responding after you make only three concurrent HTTP connections to stress test applications in SQL Server Analysis Services SP3 Q903005 KB903005 January 17, 2015
896560 Hotfix files are not removed when you try to uninstall a SQL Server 2000 64-bit hotfix or a SQL Server 2000 Analysis Services 64-bit hotfix that you installed by using Windows Installer 2.0 Q896560 KB896560 January 17, 2015
842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services Q842440 KB842440 January 17, 2015
815672 How to use XML in connected and disconnected ADO.NET applications by using Visual C# .NET or Visual C# 2005 Q815672 KB815672 January 17, 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
833422 How to move your Microsoft Project Server 2002 and SharePoint Team Services Web site to a new server Q833422 KB833422 January 5, 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
241249 HOW TO: Obtain a List of DTS Packages Q241249 KB241249 June 22, 2014
907323 Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 Q907323 KB907323 June 20, 2014
842422 How to create a bar graph that has a trend line in a chart in Report Designer Q842422 KB842422 June 20, 2014
196909 How to increase the number of SQL Server error logs Q196909 KB196909 May 9, 2014
822985 Hotfix Information for Build 8.0.861.0 of SQL Server 2000 Analysis Services 64 bit Q822985 KB822985 February 27, 2014
818963 How to prevent a session reset on HTTP connections for Analysis Services 2000 Service Pack 3 Q818963 KB818963 February 27, 2014
818847 How to troubleshoot customer issues by using Analysis Manager and OLAP Q818847 KB818847 February 27, 2014
817232 How to rebuild the master database on a SQL Server 2000 (64-bit) cluster Q817232 KB817232 February 27, 2014
815013 How To Upgrade an instance of Microsoft SQL Server 2000 Desktop Engine to SQL Server 2000 Service Pack 3 Q815013 KB815013 February 27, 2014
814084 How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Content Management Server Q814084 KB814084 February 27, 2014
281430 How to create a user-defined class to retrieve XML data from SQL Server 2000 in Visual C++ 6.0 Q281430 KB281430 December 27, 2013
315463 How to implement a SQL Server 2000 Desktop Engine callback function and example Q315463 KB315463 November 2, 2013
304215 How to create multiple distinct count measures in a single cube Q304215 KB304215 November 2, 2013
304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync Q304058 KB304058 November 2, 2013
302349 HOWTO: Perform RDA Pull by Using SSCERelay and ActiveSync Q302349 KB302349 November 2, 2013
280514 How To Use AppendChunk and GetChunk with NText Columns in a SQL Server CE Database Q280514 KB280514 November 2, 2013
917829 How to set the memory conservation threshold for SQL Server 2000 Analysis Services 32-bit edition on a 64-bit version of Windows Q917829 KB917829 November 1, 2013
828280 How to configure an instance of SQL Server 2000 Analysis Services to use Kerberos authentication Q828280 KB828280 October 26, 2013
316498 How to obtain the latest SQL Server 2000 Windows CE Edition 1.1 service pack Q316498 KB316498 October 26, 2013
314514 HOW TO: Synchronize Mobile Databases by Using SQL Server CE Relay Q314514 KB314514 October 26, 2013
280352 How To Install SQL Server CE from the Command Line and Generate a Log File Q280352 KB280352 October 26, 2013
279761 How To Use the ADOCE 3.1 Seek Method with SQL Server CE Q279761 KB279761 October 26, 2013
276985 How To Use SQL Server CE OLE DB Provider-Specific Properties in eVB Q276985 KB276985 October 26, 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
827422 How to troubleshoot connectivity issues in SQL Server 2000 Q827422 KB827422 July 11, 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
311762 How to identify which MSI file was used for an existing MSDE installation Q311762 KB311762 July 30, 2012
330014 How to upgrade an Internet Information Services server after applying SQL Server 2000 Service Pack 3 or SQL Server 2000 Service Pack SP3a Q330014 KB330014 September 17, 2011
276553 How to enable SSL encryption for SQL Server 2000 if you have a valid Certificate Server Q276553 KB276553 September 17, 2011
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
2406745 How to calculate Previous Period Growth in SQL Server Analysis Services Q2406745 KB2406745 October 20, 2010
263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 September 15, 2009
230590 How to archive more than six SQL Server error logs Q230590 KB230590 July 16, 2008
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
834124 How to troubleshoot a SQL Server 8198 error Q834124 KB834124 March 13, 2008
328587 How to create a DTS custom task by using Visual Basic .NET Q328587 KB328587 December 7, 2007
870617 How to add or modify licenses in SQL Server 2000 Q870617 KB870617 December 3, 2007
816674 "HTTP Error 401.3 Access Denied" Error Message When You View a SQL Server 2000 Service Pack 2 Database on Windows Server 2003 Q816674 KB816674 December 3, 2007
325877 How to control access to a database on a Web server in Windows Server 2003 Q325877 KB325877 December 3, 2007
240867 How to move, copy, and back up full-text catalog folders and files Q240867 KB240867 November 30, 2007
820675 How To Implement Bidirectional Transactional Replication Q820675 KB820675 November 26, 2007
818368 How to add SQL Server 2000 Stored Procedures to Visual SourceSafe by using Visual Studio .NET Q818368 KB818368 November 26, 2007
827968 How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database Q827968 KB827968 November 20, 2007
325003 How to manage the SQL Server Desktop Engine (MSDE 2000) or SQL Server 2005 Express Edition by using the osql utility Q325003 KB325003 November 14, 2007
324992 How to use replication with SQL Server 2000 Desktop Engine (MSDE 2000) Q324992 KB324992 November 14, 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
897349 How to configure SQL Mail to use an Internet mail server by using Outlook 2003 Q897349 KB897349 November 2, 2007
814130 How to help secure network connectivity for SQL Server 2000 local databases Q814130 KB814130 October 29, 2007
314131 How To Create Patch Files for the MSDE 2000 Sample.msi File Q314131 KB314131 October 29, 2007
308023 How to cluster SQL Server 2000 Analysis Services in Windows 2000 and in Windows Server 2003 Q308023 KB308023 October 29, 2007
841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
822853 How To: Stop a Server-Side Trace in SQL Server 2000 Q822853 KB822853 May 16, 2007
815671 How to use XML in connected and disconnected ADO.NET applications in Visual C++ Q815671 KB815671 May 13, 2007
811326 How To Upgrade the Master and the Target Servers (MSX/TSX) to SQL Server 2000 Service Pack 3 Q811326 KB811326 May 10, 2007
830210 How to add an article to an existing snapshot or to a transactional publication by using system stored procedures Q830210 KB830210 April 23, 2007
888265 How to move Microsoft Provisioning Server (MPS) databases to a clustered virtual SQL Server 2000 named instance Q888265 KB888265 April 17, 2007
324998 How to obtain and install SQL Server 2000 Desktop Engine (MSDE 2000) Q324998 KB324998 March 29, 2007
317328 HOW TO: Troubleshoot a SQL Server Desktop Engine 2000 Installation and Upgrade Q317328 KB317328 March 29, 2007
312399 HOW TO: Archive and Restore an Analysis Services Database from the Command Prompt in SQL Server 2000 Analysis Services Q312399 KB312399 March 29, 2007
301217 HOW TO: Prebuild a Database in SQL Server CE Q301217 KB301217 March 29, 2007
814463 How to specify a strong SA password when you install SQL Server 2000 Desktop Engine (MSDE 2000) Q814463 KB814463 March 22, 2007
841706 How to install key products from the MSDN Enterprise subscription Q841706 KB841706 March 20, 2007
841256 How to enable SQL Server 2000 Analysis Services and OLAP Services on computers that are running Windows XP SP2 Q841256 KB841256 March 20, 2007
897121 How to disable client-side printing by using the EnableClientPrinting system property in SQL Server 2000 Reporting Services Service Pack 2 Q897121 KB897121 March 15, 2007
311021 HOW TO: Manage Quotation Marks in Concatenated SQL Literals by Using ADO.NET and Visual C# .NET Q311021 KB311021 March 9, 2007
827449 How to manually reinstall the Microsoft Search service for an instance of SQL Server 2000 Q827449 KB827449 March 6, 2007
814109 How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Commerce Server Q814109 KB814109 February 23, 2007
315823 How To Execute Distributed Transaction Using ODBC API with SQL Server Q315823 KB315823 February 23, 2007
287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
279552 How To Delete a SQL Server CE Database in an Application Q279552 KB279552 February 22, 2007
162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
827690 How to use Sqldumper.exe to generate dump files for Windows applications Q827690 KB827690 January 18, 2007
320873 How to manually remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) instance Q320873 KB320873 January 15, 2007
320785 HOW TO: Create a Database, a Table, and Run a Query (SQL Server CE Sample) Q320785 KB320785 January 3, 2007
318639 HOW TO: Store and Retrieve an Image File with SQL Server CE and eVB Q318639 KB318639 January 3, 2007
319016 How to change domains for a SQL Server 2000 failover cluster Q319016 KB319016 December 19, 2006
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
814086 How to Install SQL Server 2000 Security Patch MS02-061 or SP3 with BizTalk Server Q814086 KB814086 November 24, 2006
294349 How To Use ADO and SQL Server to Select Multiple Records by Unique Field Q294349 KB294349 November 23, 2006
888526 How to set up application names in SQL Server 2000 Analysis Services Q888526 KB888526 November 21, 2006
828279 How To: Traverse an ADO MD Cellset Object by Using Visual C# .NET Q828279 KB828279 November 21, 2006
301537 How To Obtain the Current Day with a MDX Query or Expression in SQL Server 2000 Analysis Services Q301537 KB301537 November 21, 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
276220 HOW TO: Use KEEPFIXED PLAN to Disable Stored Procedure Recompilations Q276220 KB276220 July 19, 2006
244263 How sorting works in OLAP Services Q244263 KB244263 July 6, 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
307224 How to use XML in connected and disconnected ADO.NET applications Q307224 KB307224 May 23, 2006
326909 How to create a Data Transformation Services custom task by using Visual C# .NET Q326909 KB326909 May 22, 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
841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000 Q841252 KB841252 April 18, 2006
841251 How to enable SQL Server connectivity on Windows XP Service Pack 2 Q841251 KB841251 April 18, 2006
870675 How to set up SQL Mail with an Internet mail server by using Outlook 2002 Q870675 KB870675 April 7, 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
321063 How to troubleshoot the "Setup failed to perform required operations on the cluster nodes" error message Q321063 KB321063 April 7, 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
841705 How to set up a development environment from the MSDN Professional Subscription Q841705 KB841705 March 7, 2006
318124 How to set up development environment from MSDN Professional Subscription Q318124 KB318124 March 6, 2006
318114 How to install key products from the MSDN Enterprise subscription Q318114 KB318114 January 20, 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
285097 How to change the default login authentication mode to SQL while installing SQL Server 2000 Desktop Engine by using Windows Installer Q285097 KB285097 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
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
240221 HOW TO: Handle Errors in Data Transformation Services "Package" and "Step" Objects Q240221 KB240221 December 20, 2005
298568 How to rebuild the master database on a virtual SQL Server instance Q298568 KB298568 December 10, 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
272266 How To Retrieve XML Data by Using a Template File in an ASP Client Q272266 KB272266 November 22, 2005
272184 How To Retrieve XML Data with an XPath Query in an ASP Client Q272184 KB272184 November 22, 2005
271621 How To Retrieve XML Data with a Template File from a Visual Basic Client Q271621 KB271621 November 22, 2005
325806 How to use the SQL Server CE Connectivity Management utility Q325806 KB325806 September 9, 2005
316717 HOW TO: Create a Package With Visual C++ Q316717 KB316717 August 15, 2005
315661 How to run a SQL Server Data Transformation Services package from Visual Basic Q315661 KB315661 August 4, 2005
810885 High-end disk subsystems may experience error 17883 Q810885 KB810885 July 20, 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
320123 HOW TO: Add Columns in a Rollup Subscriber Topology Q320123 KB320123 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
156099 HOW TO: Debug an Extended Stored Procedure Q156099 KB156099 March 14, 2005
151599 HOW TO: Process Results in an Embedded SQL Application Q151599 KB151599 March 14, 2005
194522 How to Use ListIndexedColumns in SQL-DMO by Using Visual Basic Q194522 KB194522 March 2, 2005
151607 HOW TO: Using DB-LIBRARY in a Threaded Application Q151607 KB151607 February 14, 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
836064 How to upgrade from Reporting Services Beta 2 to Reporting Services and preserve the existing data and the key Q836064 KB836064 January 21, 2005
80397 How to implement password expiration dates for SQL Server 2000 or SQL Server 7.0 login IDs Q80397 KB80397 January 10, 2005
326613 How to distribute and how to install SQL-DMO for SQL Server 2000 Q326613 KB326613 December 20, 2004
243428 How to move extended stored procedures out of process Q243428 KB243428 November 3, 2004
281574 How to upgrade to SQL Server 2000 Retail Version after SQL Server 2000 Evaluation Edition expires Q281574 KB281574 September 29, 2004
278872 How To Specify Parameters for an XML Template Query from Visual Basic Q278872 KB278872 August 30, 2004
841253 How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2 Q841253 KB841253 August 13, 2004
841695 How to establish and enforce encrypted multiprotocol connections in SQL Server 2000 Q841695 KB841695 July 15, 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
278500 How To Specify an XSL File to Transform the XML Stream from a Query with SQL Server 2000 Q278500 KB278500 July 13, 2004
273953 How to Check the Status of a Commerce Server Direct Mail Campaign Q273953 KB273953 July 13, 2004
272269 How To Retrieve XML Data by Using a SQL XML Query in an ASP Client Q272269 KB272269 July 13, 2004
271689 How To Run Singleton SELECT Queries in a Visual Basic Client Q271689 KB271689 July 13, 2004
271620 How To Retrieve XML Data by Using a SQL XML Query in a Visual Basic Client Q271620 KB271620 July 13, 2004
271619 How To Retrieve XML Data by Using an XPath Query in a Visual Basic Client Q271619 KB271619 July 13, 2004
274189 HOWTO: Insert New Values to a Uniqueidentifier Column in SQL Server CE Q274189 KB274189 July 12, 2004
273580 HOWTO: Look Up Error Codes Related to SQL Server CE Q273580 KB273580 July 12, 2004
313225 How To Connect to a SQL Server 2000 Named Instance with JDBC Q313225 KB313225 July 2, 2004
313130 How To Retrieve @@IDENTITY Value Using JDBC Q313130 KB313130 July 2, 2004
319648 How to program the SQL Snapshot and SQL Distribution control by using Visual Basic .NET Q319648 KB319648 July 1, 2004
272271 How To Retrieve Relational Data with OpenXML in an ASP Client Q272271 KB272271 July 1, 2004
201785 How To Import FileSystem Data Using DTS and Index Server Q201785 KB201785 July 1, 2004
280431 How to Enable Commerce Server 2000 OLAP Reports Over HTTPS with SQL Server 2000 Q280431 KB280431 June 28, 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
316244 How to perform bulk updates and inserts by using the OpenXML method with .NET providers in Visual Basic .NET Q316244 KB316244 March 12, 2004
834305 How to use Reporting Services to configure and to access an Oracle data source Q834305 KB834305 February 28, 2004
321183 HOW TO: Troubleshoot Your SQL Mail Issue Q321183 KB321183 February 27, 2004
319985 HOW TO: Handle Data Transformation Services Package Events in Visual C# .NET Q319985 KB319985 February 25, 2004
241149 HOW TO: Automate Replication over a Dial-Up Connection Q241149 KB241149 February 23, 2004
834306 How to import reports from Microsoft Access to Reporting Services Q834306 KB834306 February 19, 2004
822642 How to configure the SQL Server Network Libraries by using SQL-DMO Q822642 KB822642 February 9, 2004
320733 How to retrieve the descendants of all the members of a dimension at a specific level or a specific distance by using the Descendants function in SQL Server 2000 Analysis Services Service Pack 3 Q320733 KB320733 February 5, 2004
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation Q303747 KB303747 January 21, 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
325004 HOW TO: Author MSDE 2000 Setup Packages by Using Visual Studio .NET Q325004 KB325004 January 7, 2004
316018 HOW TO: Update SQL Server Data by Using XML Updategrams Q316018 KB316018 December 31, 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
327123 HOW TO: Change the Owner of a User-Defined Data Type That Is in Use in SQL Server 2000 Q327123 KB327123 December 26, 2003
322002 HOW TO: Enforce Uniqueness For All Non-Null Values (ANSI UNIQUE CONSTRAINT) Q322002 KB322002 December 26, 2003
321176 HOW TO: Set Up Alternate Synchronization Partner in SQL Server 2000 Merge Replication Q321176 KB321176 December 26, 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
319649 HOW TO: Program the SQL Snapshot and SQL Distribution Control with Visual C# .NET Q319649 KB319649 December 26, 2003
319647 HOW TO: Program the SQL Merge Control by Using Visual Basic .NET Q319647 KB319647 December 26, 2003
319646 HOW TO: Program the SQL Merge Control by Using Visual C# .NET Q319646 KB319646 December 26, 2003
317734 HOW TO: Change the SQL Server 2000 Pull Subscription Working Directory Q317734 KB317734 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
316799 HOW TO: Schedule a Package with Visual C++ in SQL Server 2000 Q316799 KB316799 December 26, 2003
315968 HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET Q315968 KB315968 December 26, 2003
314823 HOW TO: Remove a SQL Server Service Pack Q314823 KB314823 December 26, 2003
283886 HOW TO: View SQL Server 2000 Performance Data Q283886 KB283886 December 26, 2003
270599 HOW TO: Programmatically Load Trace Files into Tables Q270599 KB270599 December 26, 2003
319951 HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services Q319951 KB319951 December 12, 2003
319664 HOW TO: Remove the IDENTITY Property from an Existing Column in SQL Server 2000 Q319664 KB319664 December 12, 2003
220960 How to Include Other MMCs in SQL Enterprise Manager MMC Q220960 KB220960 November 21, 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
151598 How to Use ESQL in a Threaded Application Q151598 KB151598 June 10, 2003
304123 HOW TO: Use Query Analyzer on HPC 2000 and Pocket PC 2002 Devices in SQL Server 2000 Windows CE 1.1 Q304123 KB304123 November 25, 2002
317032 HOW TO: Change the Temp Database Location in SQL Server CE Q317032 KB317032 October 26, 2002

SQL Server 2000 articles, fixes and updates - letter H