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

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

18) 7/20/2004 246824246824  246824.html">FIX: Memory Leak May Occur When Calling Bulk Insert From a Stored Procedure
(246824) - A memory leak in Sqlservr.exe occurs with each execution of a BULK INSERT that is called from a stored procedure. If the stored procedure is run by a recurring task, it is possible to experience access violations or other errors.

19) 7/20/2004 241678241678  241678.html">FIX: Replication Merge JOIN Filters May not be Completely Evaluated when a Filtered Table is Modified
(241678) - By design initial synchronization of existing data rows, on the publisher, that do not meet established filter criteria are not moved to the subscriber. However, some modification sequences making the filter criteria valid for a subscriber, after...

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

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

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

23) 7/17/2004 266368266368  266368.html">FIX: Updates That Use LEFT OUTER JOIN May Not Complete if Parallelism Is Used
(266368) - An UPDATE query that uses a LEFT OUTER JOIN may not complete until the user manually stops the query's execution. To determine if you are encountering this bug, examine the sysprocesses output for the UPDATE query's process ID (SPID) number. It should...

24) 7/17/2004 256282256282  256282.html">How To Write a T-SQL Query that Computes and Displays the Percentage of Total Records Aggregated in Each Group of Records Generated by a GROUP BY Clause
(256282) - T-SQL does not contain a built in aggregate function that you can use directly in a grouping query to compute and display the percentage of the total number of rows aggregated in each group of records generated by the GROUP BY clause. For example, in...

25) 7/17/2004 248999248999  248999.html">INF: Readme.txt for SQL Server 7.0 SP2 Beta
(248999) - ctimon/stephd Release version of Readme is available as Q254555 95082 This article is a copy of the Readme.txt file included in Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0. NOTE: Right now, the service pack beta is...

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

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

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

29) 7/15/2004 291255291255  291255.html">BUG: IsAlive Check Does Not Run Under the Context of the BUILTIN\Administrators Account
(291255) - In SQL Server 2000 Books Online, under the "Usage Considerations" heading in the "Creating a Failover Cluster" topic, the following is mentioned: You should not remove the BUILTIN\Administrators account from SQL Server. The IsAlive thread runs under...

30) 7/15/2004 279761279761  279761.html">How To Use the ADOCE 3.1 Seek Method with SQL Server CE
(279761) - This article describes how to use the Microsoft ADO for Windows CE SDK (ADOCE) 3.1 Seek method with SQL Server 2000 Windows CE Edition. One of the most widely used methods by clients on SQL Server CE indexes is Seek . The Seek method provides the...