SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
Adds subscribers to a given publication to the recipient list for passthrough statements.
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. |
sp_passthrough_piece procedure
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.
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.
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