Home Forums SQL Server 7,2000 Replication The subscription(s) have been marked inactive..... RE: The subscription(s) have been marked inactive.....

  • ^^^Thanks for the script.

    FYI- I did more research and found that it appears the subscriptions will be marked inactive if nothing is replicated in 48 hours. To resolve this, I have an update script running every 12 hours that updates a users lock status to unlocked or something similar. Just update something that's replicated and so far I have not had any subscriptions marked as inactive for a few weeks now. Hope this helps.