Suspends a specified subscription.
sp_suspendsub sub_name
is the name of the subscription to suspend.
sp_suspendsub subdoc
Suspends the subscription subdoc.
When a subscription is suspended, all distribution of data to the replicate objects identified in the subscription stops, and the Distributor component records a locator value for that subscription, which it uses to determine where to start scanning in the stable queue when the subscription is resumed.
When sp_suspendsub is invoked, it suspends the specified subscription (sub_name).
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_helpsub, sp_resumesub
