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

sp_passthrough_stop procedure

Purpose 

Resents passthrough mode

Syntax 

sp_passthrough_stop

See also 

sp_passthrough procedure

sp_passthrough_subscription procedure

sp_passthrough_user procedure

Description 

The sp_passthrough_stop procedure resents the list of recipients of passthrough statements to be empty, and clears any statements that are currently being built.

Example 

• The following statement resets the passthrough recipient list to be empty.

  exec sp_passthrough_stop
  go