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.

309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 February 10, 2012
321185 How to determine the version and edition of SQL Server and its components Q321185 KB321185 January 17, 2012
823938 How to configure an instance of SQL Server to listen on a specific TCP port or dynamic port Q823938 KB823938 December 13, 2011
321686 How to import data from Excel to SQL Server Q321686 KB321686 November 24, 2011
301240 How To Implement Forms-Based Authentication in Your ASP.NET Application by Using C#.NET Q301240 KB301240 September 22, 2011
968872 How do I open the firewall port for SQL Server on Windows Server 2008? Q968872 KB968872 September 17, 2011
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
322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition Q322336 KB322336 September 17, 2011
319723 How to use Kerberos authentication in SQL Server Q319723 KB319723 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
265808 How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server Q265808 KB265808 September 17, 2011
246133 How to transfer logins and passwords between instances of SQL Server Q246133 KB246133 September 17, 2011
237980 How to convert an Access database to SQL Server Q237980 KB237980 September 17, 2011
224071 How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server Q224071 KB224071 September 17, 2011
186133 How to dynamically number rows in a SELECT Transact-SQL statement Q186133 KB186133 September 17, 2011
139444 How to remove duplicate rows from a table in SQL Server Q139444 KB139444 September 17, 2011
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 August 29, 2011
271509 How to monitor blocking in SQL Server 2005 and in SQL Server 2000 Q271509 KB271509 July 29, 2011
918615 How to create a trace by using SQL Profiler in Microsoft SQL Server 2000 to troubleshoot a Microsoft Axapta issue Q918615 KB918615 July 28, 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
811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 7, 2010
314546 How to move databases between computers that are running SQL Server Q314546 KB314546 July 13, 2009
137983 How to troubleshoot orphaned connections in SQL Server Q137983 KB137983 April 30, 2009
263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 April 3, 2009
244980 How to change the network IP addresses of SQL Server failover cluster instances Q244980 KB244980 March 11, 2009
207595 How to do SQL Server 2000 distributed queries with FoxPro .dbf files Q207595 KB207595 March 4, 2009
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 February 11, 2009
240872 How to resolve permission issues when you move a database between servers that are running SQL Server Q240872 KB240872 January 27, 2009
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 December 29, 2008
319942 How to determine proper SQL Server configuration settings Q319942 KB319942 July 17, 2008
230590 How to archive more than six SQL Server error logs Q230590 KB230590 July 16, 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
953740 How to identify and enable disabled SQL Server instances in SQL Server 2000 Q953740 KB953740 June 19, 2008
890775 How to enable non-sysadmin accounts to execute the "xp_cmdshell" extended stored procedure in SQL Server 2000 Q890775 KB890775 June 2, 2008
290211 How to obtain the latest SQL Server 2000 service pack Q290211 KB290211 May 9, 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
907323 Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 Q907323 KB907323 November 29, 2007
828280 How to configure an instance of SQL Server 2000 Analysis Services to use Kerberos authentication Q828280 KB828280 November 26, 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
931975 How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 Q931975 KB931975 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
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
324321 How to troubleshoot error 15401 Q324321 KB324321 November 9, 2007
910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
906566 How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 Q906566 KB906566 November 2, 2007
897349 How to configure SQL Mail to use an Internet mail server by using Outlook 2003 Q897349 KB897349 November 2, 2007
306397 How to use Excel with SQL Server linked servers and distributed queries Q306397 KB306397 November 2, 2007
196909 How to increase the number of SQL Server error logs Q196909 KB196909 November 2, 2007
70956 How to remove duplicate rows from a SQL Server table by using a script Q70956 KB70956 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
311762 How to identify which MSI file was used for an existing MSDE installation Q311762 KB311762 October 29, 2007
308157 How To Implement Forms-Based Authentication in Your ASP.NET Application by Using Visual Basic .NET Q308157 KB308157 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
294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 August 21, 2007
325335 How to transfer a database from one collation to another collation in SQL Server Q325335 KB325335 August 16, 2007
290991 How to manually remove SQL Server 2000 default, named, or virtual instance Q290991 KB290991 June 11, 2007
815013 How To Upgrade an instance of Microsoft SQL Server 2000 Desktop Engine to SQL Server 2000 Service Pack 3 Q815013 KB815013 May 31, 2007
842422 How to create a bar graph that has a trend line in a chart in Report Designer Q842422 KB842422 May 18, 2007
319930 How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition Q319930 KB319930 May 18, 2007
822853 How To: Stop a Server-Side Trace in SQL Server 2000 Q822853 KB822853 May 16, 2007
317604 HOW TO: Configure SQL Server to Store ASP.NET Session State Q317604 KB317604 May 16, 2007
815672 How to use XML in connected and disconnected ADO.NET applications by using Visual C# .NET or Visual C# 2005 Q815672 KB815672 May 13, 2007
815671 How to use XML in connected and disconnected ADO.NET applications in Visual C++ Q815671 KB815671 May 13, 2007
814576 How to consolidate physical files and rename the logical file name in SQL Server 2000 and in SQL Server 2005 Q814576 KB814576 May 11, 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
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 April 3, 2007
842419 How to grant permissions to a custom assembly that is referenced in a report in Reporting Services Q842419 KB842419 April 3, 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
315521 How to troubleshoot SQL Server merge replication problems Q315521 KB315521 March 29, 2007
314514 HOW TO: Synchronize Mobile Databases by Using SQL Server CE Relay Q314514 KB314514 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
311209 HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management Q311209 KB311209 March 27, 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
841549 How to enable ports on Windows XP SP2 for Analysis Services and SQL Server 7.0 OLAP Services Q841549 KB841549 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
323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 February 22, 2007
321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 February 22, 2007
304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync Q304058 KB304058 February 22, 2007
302349 HOWTO: Perform RDA Pull by Using SSCERelay and ActiveSync Q302349 KB302349 February 22, 2007
288809 How to recover SQL Server after a tempdb database is marked suspect Q288809 KB288809 February 22, 2007
287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
280514 How To Use AppendChunk and GetChunk with NText Columns in a SQL Server CE Database Q280514 KB280514 February 22, 2007
280352 How To Install SQL Server CE from the Command Line and Generate a Log File Q280352 KB280352 February 22, 2007
279761 How To Use the ADOCE 3.1 Seek Method with SQL Server CE Q279761 KB279761 February 22, 2007
279552 How To Delete a SQL Server CE Database in an Application Q279552 KB279552 February 22, 2007
276985 How To Use SQL Server CE OLE DB Provider-Specific Properties in eVB Q276985 KB276985 February 22, 2007
262499 How to specify output parameters when you use the sp_executesql stored procedure in SQL Server Q262499 KB262499 February 22, 2007
246800 How to correctly parse quotation marks in Full Text Search queries Q246800 KB246800 February 22, 2007
243899 How to access additional information about errors that are returned when you use the OLE Automation system stored procedures Q243899 KB243899 February 22, 2007
199037 How to capture error messages that are sent to clients from an instance of SQL Server Q199037 KB199037 February 22, 2007
198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 February 22, 2007
162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
814084 How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Content Management Server Q814084 KB814084 February 20, 2007
306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server Q306212 KB306212 February 16, 2007
243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
818847 How to troubleshoot customer issues by using Analysis Manager and OLAP Q818847 KB818847 February 5, 2007
920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 January 26, 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
833422 How to move your Microsoft Project Server 2002 and SharePoint Team Services Web site to a new server Q833422 KB833422 January 5, 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
914174 How to build an OLE DB application for SQL Server CE in Visual Studio 2005 Q914174 KB914174 December 8, 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
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 21, 2006
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 November 21, 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
818963 How to prevent a session reset on HTTP connections for Analysis Services 2000 Service Pack 3 Q818963 KB818963 November 21, 2006
304215 How to create multiple distinct count measures in a single cube Q304215 KB304215 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
169377 How to access SQL Server in Active Server Pages Q169377 KB169377 November 20, 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
312839 How to send e-mail without using SQL Mail in SQL Server Q312839 KB312839 September 13, 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
316498 How to obtain the latest SQL Server 2000 Windows CE Edition 1.1 service pack Q316498 KB316498 August 30, 2006
239885 How to change service accounts for a clustered computer that is running SQL Server Q239885 KB239885 August 16, 2006
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 July 28, 2006
276220 HOW TO: Use KEEPFIXED PLAN to Disable Stored Procedure Recompilations Q276220 KB276220 July 19, 2006
921928 How to configure SQL Server 2000 to use non-uniform memory access (NUMA) Q921928 KB921928 July 14, 2006
244263 How sorting works in OLAP Services Q244263 KB244263 July 6, 2006
917400 How to obtain the SQL Server Runtime license Q917400 KB917400 June 23, 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
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 June 7, 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
810056 How to manually re-create the resource-specific registry keys for SQL Server cluster resources Q810056 KB810056 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
313037 How to upgrade SQL Server clusters to Windows Server 2003 Q313037 KB313037 April 7, 2006
290624 How to configure MSDTC in a Windows 2000 cluster environment Q290624 KB290624 April 7, 2006
817232 How to rebuild the master database on a SQL Server 2000 (64-bit) cluster Q817232 KB817232 April 6, 2006
916665 How to cluster SQL Server 2000 Analysis Services on a cluster that is running a 64-bit version of Windows Q916665 KB916665 March 30, 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
318605 How SQL Server uses a certificate when the Force Protocol Encryption option is turned on Q318605 KB318605 January 2, 2006
312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 December 30, 2005
316005 How to import XML into SQL Server with the XML Bulk Load component Q316005 KB316005 December 23, 2005
308737 How to identify the cause of recompilation in an SP:Recompile event Q308737 KB308737 December 23, 2005
298475 How to troubleshoot SQL Server performance issues Q298475 KB298475 December 23, 2005
280106 How to set up and troubleshoot a linked server to an Oracle database in SQL Server Q280106 KB280106 December 23, 2005
274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 December 23, 2005
314520 How to pass a variable to a linked server query Q314520 KB314520 December 22, 2005
309256 How to troubleshoot SQL Server error 8645 Q309256 KB309256 December 22, 2005
321247 How to configure security for SQL Server log shipping Q321247 KB321247 December 21, 2005
307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 December 21, 2005
288577 How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server Q288577 KB288577 December 20, 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
111401 How to iterate through a result set by using Transact-SQL in SQL Server Q111401 KB111401 December 20, 2005
243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions Q243589 KB243589 December 15, 2005
175574 How to rotate a table in SQL Server Q175574 KB175574 December 15, 2005
300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 December 14, 2005
294453 How to set up SQL Server to listen on multiple static TCP ports Q294453 KB294453 December 14, 2005
321836 How to retrieve a specific table or rows from database backups or transaction log backups in SQL Server Q321836 KB321836 December 13, 2005
75722 How to reduce lock contention in SQL Server Q75722 KB75722 December 13, 2005
298568 How to rebuild the master database on a virtual SQL Server instance Q298568 KB298568 December 10, 2005
303722 How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Server Q303722 KB303722 December 8, 2005
243588 How to troubleshoot the performance of Ad-Hoc queries in SQL Server Q243588 KB243588 December 8, 2005
138541 How to use Odbcping.exe to verify ODBC connectivity to SQL Server Q138541 KB138541 December 7, 2005
69133 How to convert CHAR values into DATETIME values in SQL Server Q69133 KB69133 December 1, 2005
313295 How to use the server name parameter in a connection string to specify the client network library Q313295 KB313295 November 30, 2005
324401 How to manually remove a replication in SQL Server 2000 or in SQL Server 2005 Q324401 KB324401 November 23, 2005
115519 How to use the Findstr tool to scan SQL error log files or DBCC output files for analysing 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
822985 Hotfix Information for Build 8.0.861.0 of SQL Server 2000 Analysis Services 64 bit Q822985 KB822985 October 5, 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
218592 How to perform a SQL Server distributed query with OLAP Server Q218592 KB218592 July 25, 2005
810885 High-end disk subsystems may experience error 17883 Q810885 KB810885 July 20, 2005
815154 HOW TO: Configure SQL Server Security for .NET Applications Q815154 KB815154 July 8, 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
281430 How to create a user-defined class to retrieve XML data from SQL Server 2000 in Visual C++ 6.0 Q281430 KB281430 June 2, 2005
842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services Q842440 KB842440 April 22, 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
555266 How to pass array of values into SQL Server stored procedure using XML and Visual Basic .NET Q555266 KB555266 March 1, 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
203638 How to return information about SQL Server linked servers Q203638 KB203638 February 2, 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
272067 How To Get a Record Count from a SQL Server CE Recordset Q272067 KB272067 October 6, 2004
315463 How to implement a SQL Server 2000 Desktop Engine callback function and example Q315463 KB315463 October 5, 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
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 August 20, 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
555128 HowTo: Backup to UNC name using Database Maintenance Wizard Q555128 KB555128 June 2, 2004
827422 How to troubleshoot connectivity issues in SQL Server 2000 Q827422 KB827422 April 28, 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
225545 HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager Q225545 KB225545 January 20, 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
313100 HOW TO: Get Started with Microsoft JDBC Q313100 KB313100 January 9, 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
241249 HOW TO: Obtain a List of DTS Packages Q241249 KB241249 December 27, 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
320141 HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET Q320141 KB320141 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
555017 HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003 Q555017 KB555017 December 18, 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
327489 HOW TO: Use the DisallowAdHocAccess Setting to Control Access to Linked Servers Q327489 KB327489 October 30, 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