106) 5/27/2004 841845841845  841845.html">The ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL Server 2000
(841845) - Provides information about the ORDER BY clause in views, inline functions, derived tables, and subqueries.

107) 5/26/2004 839279839279  839279.html">You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2
(839279) - After you install Microsoft Windows XP Service Pack 2, you may receive error 7391 when a distributed transaction runs against a linked server. This article discusses how to work around this problem.

108) 5/25/2004 841394841394  841394.html">You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2
(841394) - Client connections to SQL Server instances or to MSDE instances that are installed on computers that are running Microsoft Windows XP Service Pack 2 may receive an error message. This article discusses how to work around this problem.

109) 5/21/2004 839417839417  839417.html">Blocking problems may occur when you use SQL Server Enterprise Manager to make design changes to a table
(839417) - Describes blocking problems that may occur when you use SQL Server Enterprise Manager to make design changes to a SQL Server table.

110) 5/21/2004 842012842012  842012.html">How to publish a computer that is running SQL Server 2000 at a computer that is running ISA Server 2004
(842012) - Describes how to publish a computer that is running SQL Server at a computer that is running ISA Server 2004.

111) 5/21/2004 832674832674  832674.html">FIX: You receive a "Failed to reserve contiguous memory of Size= <size>" error message when you run a query that has many predicates that are a sql_variant data type in SQL Server 2000
(832674) - When you run a query that has many sql_variant predicates, you may receive an error message. This article contains a fix for this problem.

112) 5/21/2004 841061841061  841061.html">Your SQL Server Desktop Engine installation may stop responding when you use the WaitForSingleObject function in a Win32 bootstrap wrapper application
(841061) - Describes a problem that occurs when you use the WaitForSingleObject function in the Win32 bootstrap wrapper application to install SQL Server Desktop Engine, and the installation stops responding.

113) 5/21/2004 295772295772  295772.html">How to debug full-text search when a 7608 (0x80004005) error message occurs in SQL Server
(295772) - This article contains a brief description about the interaction between SQL Server and MSSearch. This article also describes how to set up full-text search, common resolutions you can use for the 7608 error message, and how to debug full-text search...

114) 5/21/2004 841705841705  841705.html">How to set up a development environment from the MSDN Professional subscription
(841705) - Explains how to install Visual Studio .NET 2003 and SQL Server Desktop Engine. Guides you through the step-by-step process and explains how to verify that the installations are successful.

115) 5/21/2004 841706841706  841706.html">How to install key products from the MSDN Enterprise subscription
(841706) - Explains how to install Visual Studio .NET 2003 and SQL Server 2000 Developer Edition. Guides you through the installation process of Visual Studio .NET 2003 and SQL Server 2000 at each step and explains how to verify the installations.

116) 5/20/2004 260512260512  260512.html">Frequently asked questions - SQL Server 2000 - Tools
(260512) - This article is meant to address frequently asked questions regarding SQL Server 2000, version 8.0 administration tools.

117) 5/19/2004 841251841251  841251.html">How to enable SQL Server connectivity on Windows XP Service Pack 2
(841251) - This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2.

118) 5/19/2004 309802309802  309802.html">FIX: A call to a RAISERROR statement in a Transact-SQL batch can cause a SQLAgent job to fail and to lose output in SQL Server
(309802) - When a SQLAgent job step type is Transact-SQL script, and when the statements in the Command field of the New Job Step - <SQL Server Instance Name> dialog box call a Transact-SQL RAISERROR statement with a severity level of 11 or higher without the...

119) 5/19/2004 841252841252  841252.html">How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000
(841252) - This article describes how to determine if SQL Server is using a static or a dynamic port, and how to manually enable TCP/IP on Microsoft Windows XP Service Pack 2 for Microsoft SQL Server 2000. By default, Windows Firewall is enabled on computers...

120) 5/14/2004 841401841401  841401.html">You may notice incorrect values for the "Active Transactions" counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer
(841401) - Fixes the problem of incorrect large values for the "Active Transactions" counter for the "_Total" instance of the "SQLServer:Databases" object in Performance Monitor when multiple transactions are run on an SMP computer that is running SQL Server.