1) 10/7/2004 870654870654  870654.html">FIX: You may receive a 547 error message when you try to update an instance and application databases of SQL Server 2000 Notification Services by using the NSControl Update command
(870654) - Describes a hotfix for the 547 error message that you may receive when you run the NSControl Update command to re-create a distributor in the NSDistributors table.

2) 10/7/2004 884593884593  884593.html">SQL Server 2000 may overcommit physical memory on computers that are running Windows XP
(884593) - Describes a problem that occurs when SQL Server 2000 may commit more memory than is physically available on a computer that is running Windows XP. Includes a resolution for the problem.

3) 9/30/2004 296098296098  296098.html">FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition
(296098) - The xp_sendmail extended stored procedure may raise the following error if you try to send query results by e-mail using the @attach_results parameter from SQL Server 2000 Personal Edition: Server: Msg 18024, Level 16, State 1, Line 0 xp_sendmail:...

4) 9/29/2004 273557273557  273557.html">BUG: Floating point underflow exceptions may occur with data below the minimum float exponent
(273557) - If the following conditions are all true, Microsoft SQL Server may store floating point data with an exponent lower than -308, which may cause floating point underflow exceptions that terminate a clients connection to SQL Server: The client...

5) 9/29/2004 152354152354  152354.html">Database dumps and restore may fill up MSDB database
(152354) - SQL Executive-based tasks fail and the following error message is returned: Error: 1105, Severity : 17, State 2 Can't allocate space for object '%.*s' in database '%.*s' because the '%.*s' segment is full. If you ran out of space in Syslogs, dump the...

6) 9/11/2004 883724883724  883724.html">Information about the SQL Server edition of the MPS Reporting tool
(883724) - Describes how to download, install, and run the SQL Server edition of MPS Reporting tool.

7) 9/3/2004 278872278872  278872.html">How To Specify Parameters for an XML Template Query from Visual Basic
(278872) - The functionality to specify parameters for a T-SQL or XPath query is provided by enhancements in ActiveX Data Objects (ADO) 2.6. This article presents a sample of how to specify parameters to a templated query against SQL Server 2000 from an MDAC 2.6...

8) 8/26/2004 843266843266  843266.html">Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3)
(843266) - Fixes a problem in SQL Server 2000 Service Pack 3 (SP3) where you experience blocking or performance problems because shared page locks are held until the end of the transaction.

9) 8/21/2004 883732883732  883732.html">A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server 2000
(883732) - A SQL Server cluster resource may not come online and errors are in the log files. This problem occurs if resource-specific registry keys are missing. To resolve the problem, manually create the registry keys.

10) 8/19/2004 870620870620  870620.html">DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time
(870620) - Describes a problem that occurs when your DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time. Includes several methods that you can use to work around this problem.

11) 8/18/2004 842423842423  842423.html">A call to the AuthzInitializeContextFromSid API function may fail during the delivery of an e-mail subscription
(842423) - This articles discusses a problem that you may experience with the AuthzInitializeContextFromSid API function call during the delivery of an e-mail subscription and possible resolutions for the problem.

12) 8/11/2004 241088241088  241088.html">FIX: Registry Permission Difference When You Install OLAP Services on Windows 2000
(241088) - When you install OLAP Services version 7.0 on a Windows 2000 computer, all of the local computer users receive administrators rights to administer OLAP Services. This occurs because of behavior changes in the defaults of the registry system of Windows...

13) 8/10/2004 160683160683  160683.html">How to use Editbin to adjust SQL Server thread stack size
(160683) - The Microsoft Binary File Editor (Editbin.exe) can be used to adjust the stack size for SQL Server threads, to allow a large memory configuration for SQL Server on computers that have 2 GB or more of physical RAM.

14) 8/7/2004 274036274036  274036.html">INF: How to Obtain SQL Server 6.5 Post Service Pack 5a Update
(274036) - The "More Information" section of this article describes how to obtain Microsoft SQL Server 6.5 Post Service Pack 5a Update. If you are running SQL Server 6.5 Service Pack 5 or 5a, Microsoft recommends that you apply this update to your system only if...

15) 8/6/2004 843245843245  843245.html">You may experience a significant loss of performance when a client makes multiple calls to SQL Server 2000 that are processed at the same time
(843245) - Discusses a situation where a client experiences poor performance with SQL Server 2000 when requests to the SQL Server stack up through critical sections of code.