Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

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

sp_passthrough_piece procedure

sp_passthrough_stop procedure

sp_passthrough_user procedure

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.

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