91) 6/14/2004 272439272439  272439.html">PRB: SQL 2000 Profiler Doesn't Capture SHOWPLAN Events if the BinaryData Data Column Is Not Captured
(272439) - When using the SQL Server 2000 Profiler to capture the SHOWPLAN event classes from the Performance event category, if the BinaryData data column is not captured, these events are captured but with no data in them.

92) 6/12/2004 831999831999  831999.html">FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
(831999) - Describes a fix for a problem with an AWE-enabled SQL Server using too much memory for queries that contain sort or hash operators. Under some circumstances, this may cause a BPool::Map error to be written to the SQL Server error log.

93) 6/12/2004 841856841856  841856.html">FIX: A memory leak occurs when you run queries in the same connection in Analysis Services
(841856) - Describes a problem that occurs when the memory usage of the client process that uses the Pivot Table Services client increases. Includes a hotfix that you can apply to resolve this problem.

94) 6/11/2004 838460838460  838460.html">FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later
(838460) - Fixes a problem in SQL Server 2000 where the xp_logininfo extended stored procedure may fail when you install Q825042.

95) 6/10/2004 280102280102  280102.html">How to set up a linked server to a Sybase database server and troubleshoot problems that may occur
(280102) - This step-by-step article describes how to set up a linked server to a Sybase database server on a computer that is running Microsoft SQL Server. Additionally, this article contains basic troubleshooting steps for problems that may occur when you set...

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

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

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

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

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

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

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

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

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

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