sp_passthrough_subscription procedure
Purpose Adds subscribers to a givenpublication to the recipient list for passthrough
statements.
Syntax sp_passthrough_subscriptionpublication_name,
subscribe_by
Argument Description
publication_name
Thename of the publication
subscribe_by
The subscription value for recipients to receive
passthroughstatements.
Seealso “sp_passthroughprocedure” on page 402
“sp_passthrough_pieceprocedure” on page 403
“sp_passthrough_stopprocedure” on page 405
“sp_passthrough_userprocedure” on page 407
“PASSTHROUGHstatement” on page 368
Description This is one of two waysthat you can add to the list of recipients for
passthroughstatements, the other being to use the “sp_passthrough_user
procedure”on page 407.
Theusers that are added to the recipient list by a call to the
sp_passthrough_subscriptionprocedure are all those users subscribing to
thepublication
publication_name
witha subscription valueof
subscribe_by
.
Thedefault setting for
subscribe_by
isNULL. In this case, all subscribers to
thepublication receive the passthrough statements.
Example ♦Thefollowing statement adds to the list of passthrough recipients the
subscriberor subscribers to the SalesRepData publication who use
subscriptionvalues of ‘rep1’.
sp_passthrough_subscription SalesRepData, rep1
406