Microsoft KB Archive/834670

= BUG: Subscriptions are incorrectly marked as inactive even if the subscriptions are synchronized within the maximum transaction retention period in SQL Server 7.0 =

Article ID: 834670

Article Last Modified on 2/13/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



BUG #: 200053 (SQL Server 7.0)



SYMPTOMS
In Microsoft SQL Server 7.0, although the subscriptions are synchronized within the maximum transaction retention period of the distribution database, the Distribution Cleanup Agent that is running on the distributor may incorrectly mark the subscriptions as inactive. Therefore, the Distribution Agent may fail, and you may notice 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.



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

