User's Manual

sp_passthrough_subscription procedure
Purpose Adds subscribers to a given publication to the recipient list for passthrough
statements.
Syntax sp_passthrough_subscription publication_name,
subscribe_by
Argument Description
publication_name The name of the publication
subscribe_by The subscription value for recipients to receive
passthrough statements.
See also “sp_passthrough procedure” on page 402
“sp_passthrough_piece procedure” on page 403
“sp_passthrough_stop procedure” on page 405
“sp_passthrough_user procedure” on page 407
“PASSTHROUGH statement” on page 368
Description This is one of two ways that you can add to the list of recipients for
passthrough statements, the other being to use the “sp_passthrough_user
procedure” on page 407.
The users that are added to the recipient list by a call to the
sp_passthrough_subscription procedure are all those users subscribing to
the publication publication_name with a subscription value of subscribe_by .
The default setting for subscribe_by is NULL. In this case, all subscribers to
the publication receive the passthrough statements.
Example
♦ The following statement adds to the list of passthrough recipients the
subscriber or subscribers to the SalesRepData publication who use
subscription values of ‘rep1’.
sp_passthrough_subscription SalesRepData, rep1
406