Microsoft KB Archive/823649

= FIX: Subscriptions are incorrectly marked inactive although the subscriptions are synchronized in the retention period =

Article ID: 823649

Article Last Modified on 5/26/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-





SYMPTOMS
Although the subscriptions are synchronized in the maximum transaction retention period of the distribution database in Microsoft SQL Server 2000, the Distribution Agent cleanup job that runs on the distributor may incorrectly mark the subscriptions as inactive. As a result, the Distribution Agent may fail, and you may receive the following error message in the Error message pane of the Distribution Agent Error Details dialog box:

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to obtain the latest SQL Server 2000 service pack



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

This bug was corrected in SQL Server 2000 Service Pack 3.

