Resumes all subscriptions or a specified subscription.
sp_resumesub [sub_name]
is the name of the subscription to resume.
sp_resumesub subdoc
Resumes the subscription subdoc.
When a subscription is resumed, the Distributor component evaluates the last saved locator value for that subscription, starts scanning the stable queue at the point indicated by the locator value, and starts sending processed transactions to the proxy tables for the replicate site identified by the replicate connection associated with the subscription.
When sp_resumesub is invoked with no subscription (sub_name) specified, it resumes all subscriptions for all replicate database connections.
When sp_resumesub is invoked with a subscription (sub_name) specified, it resumes the specified subscription.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_helpsub, sp_suspendsub
