106) 6/9/2004 303879303879  303879.html">Maximum number of database users and roles that you can create
(303879) - This article provides information about the maximum number of users and roles that you can create in SQL Server 7.0 and SQL Server 2000 databases. You can create a maximum of 16379 security accounts for a database. The maximum number of roles that you...

107) 6/9/2004 222106222106  222106.html">PRB: Cannot install Enterprise Edition on Windows NT Server
(222106) - Attempting to install SQL Server 7.0 from a compact disc included in a Standard Edition package may return the following error message when you attempt to install it on Windows NT Server version 4.0: The Enterprise Edition server component cannot be...

108) 6/9/2004 831801831801  831801.html">FIX: SQLStatistics function returns incorrect sort order sequence
(831801) - When you connect to Microsoft SQL Server 2000 or to Microsoft SQL Server 7.0, and you call the SQLStatistics ODBC function, you may notice that the collation is always returned as "A" regardless of the sort order sequence. You may also notice this...

109) 6/4/2004 842421842421  842421.html">You receive an error message in the Reporting Services trace log when you restart the Report Server service after you change the user account that is used to run the Report Server service
(842421) - Describes an error message that is logged in the Reporting Services trace log when Reporting Services is restarted after you change the account that runs the Report Server Windows service or the Web service.

110) 6/3/2004 842191842191  842191.html">SQL Server 2000 Windows CE Edition frequently asked questions
(842191) - Answers frequently asked questions and answers about SQL Server 2000 Windows CE Edition (SQL Server CE) version 1.0 and verision 1.1.

111) 6/3/2004 840166840166  840166.html">FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000
(840166) - Describes a problem that occurs when you use a dynamic snapshot for merge replications, and you receive an incorrect syntax error message. Includes a hotfix that you can use to resolve the problem.

112) 6/3/2004 838459838459  838459.html">FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option
(838459) - Describes a problem that may occur when a BPool::Map warning is written to the SQL Server error log when you create or rebuild indexes by using the awe enabled configuration option.

113) 5/29/2004 841487841487  841487.html">You receive a "Command line option syntax error" error message when you install SQL Server 2000 SP3
(841487) - Describes a problem that occurs when you install SQL Server 2000 SP3, and you receive a "Command line option syntax error" error message. Includes a workaround that you can use to resolve the problem.

114) 5/29/2004 832437832437  832437.html">FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000
(832437) - A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true: SQL Server loads data into a column that is a sql_variant data type. The data originates in another column that is a sql_variant data...

115) 5/29/2004 831133831133  831133.html">SQL Server clients are authenticated as guests if Simple File Sharing is enabled
(831133) - You receive the following error message: Login failed for user ' ServerName \guest' You receive this error message if either of the following conditions is true: You try to register a server in SQL Server Enterprise Manager. You try to connect to...

116) 5/29/2004 831997831997  831997.html">FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
(831997) - After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix build versions between 8.00.0859 and 8.00.0875, applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets...

117) 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.

118) 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.

119) 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.

120) 5/21/2004 823462823462  823462.html">Upgrade scenarios that are not supported by SQL Server 2000 Desktop Engine (Windows)
(823462) - Describes the upgrade scenarios that are not supported by SQL Server 2000 Desktop Engine (Windows).