SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
Resents passthrough mode
sp_passthrough_stop
sp_passthrough_subscription procedure
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.
The following statement resets the passthrough recipient list to be empty.
exec sp_passthrough_stop go