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

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

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

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

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

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

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

23) 7/24/2004 237604237604  237604.html">PRB: SQL Server Agent does not start and displays error 18456
(237604) - The SQL Server Agent Service does not start and you may see the following error message in the Windows Event Viewer: SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start). Additionally, if you attempt...

24) 7/24/2004 841375841375  841375.html">A message stating that an instance of SQL Server is vulnerable to virus attacks is logged in the application event log when you install SQL Server 2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
(841375) - When you install SQL Server 2000 SP2 or MSDE 2000 SP2 or earlier versions on computers that are running Windows XP SP2, you must install the latest SQL Server 2000 service pack or the latest MSDE 2000 service pack to help protect your computer.

25) 7/17/2004 300099300099  300099.html">PRB: Restoring Archive from Server with Metadata Format to Server with Access Repository Fails
(300099) - When attempting to restore an Analysis Services archive created on a server with the repository in Metadata Services Format to a server using the default Microsoft Access repository (Msmdrep.mdb), the following error message may appear: The archived...

26) 7/17/2004 291160291160  291160.html">FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE
(291160) - The SQL Server 2000 Books Online documentation is incorrect regarding the default value for the @terminate parameter for the sp_change_primary_role stored procedure in the msdb database.

27) 7/17/2004 286124286124  286124.html">INF: How to Reschedule a DTS Package
(286124) - If you have configured a Data Transformation Services package to execute on a schedule, you may modify the schedule by using SQL Server Enterprise Manager. However, do not change the schedule for the package by using the Schedule Package command...

28) 7/17/2004 841695841695  841695.html">How to establish and enforce encrypted multiprotocol connections in SQL Server 2000
(841695) - Describes how to enable multiprotocol encryption in SQL Server 2000 for client connections, for a specific client, and over a firewall. Also describes how to enforce multiprotocol encryption over TCP/IP and Named Pipes.

29) 7/16/2004 300080300080  300080.html">BUG: Property Changes in the Merging Changes Tab of an Indexed View Article Are Not Saved
(300080) - Indexed views are views whose results are persisted in the database and indexed for fast access. After the indexed views are created, you can publish the views as articles in Replication. If indexed views are part of a merge publication, changes to...

30) 7/16/2004 839096839096  839096.html">FIX: An access violation exception may occur when you use PDH APIs to collect performance data for several instances of SQL Server at the same time
(839096) - Describes a problem that occurs when you use PDH APIs to collect the performance data of several instances of SQL Server 2000 at the same time, and an access violation occurs. Includes a hotfix that you can install to resolve the problem.