TSQL to determine status of subscription reinitialization

  • How do I determine the initialization status of a subscription with T-SQL -- i.e, how do I determine that initialization is still in progress applying scripts, and how can I determine that it is complete -- all scripts have been applied -- the equivalent of the "Delivered snapshot..." message in Distributor to Subscriber History in Replication Monitor Suscription details (history)?

    This seems like it should be fairly straightforward, but I haven't been able to find the solution. I find lots of references to MSReplication_monitordata.status & MSdistribution_history.runstatus, but those seems to just generally indicate status, not specifically reinitialization.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply