Deletes an existing subscription.
sp_dropsub sub_name
is the name of the subscription to delete.
sp_dropsub subdoc
Deletes the subscription subdoc.
Before you invoke sp_dropsub, you must suspend the database connection using sp_suspendreplicateconn. After the subscription is deleted, you can resume the database connection with sp_resumereplicateconn.
If a subscription has any replicate article defined for it, you must drop the replicate article before you drop the subscription.
If you attempt to drop a subscription that has a replicate article defined, sp_dropsub returns an error.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_addsub, sp_dropreplicateart, sp_dropreplicateconn, sp_helpreplicateart, sp_helpreplicateconn, sp_helpsub
