Contents Index sp_hook_dbremote_end and sp_hook_ssrmt_end sp_hook_dbremote_receive_begin and sp_hook_ssrmt_receive_begin

SQL Remote User's Guide
  Utilities and Options Reference
    SQL Remote event-hook procedures

sp_hook_dbremote_shutdown and sp_hook_ssrmt_shutdown

Function 

Use this stored procedure to initiate a Message Agent shutdown.

Rows in #hook_dict table 
Name Values Description
send true or false Indicates if the process is performing the send phase of replication.
receive true or false Indicates if the process is performing the receive phase of replication
shutdown true or false This row is false when the procedure is called. If the procedure updates the row to true the Message Agent is shut down.
Description 

If a procedure of this name exists, it is called when the Message Agent is neither sending nor receiving messages, and permits a hook-initiated shutdown of the Message Agent.

Contents Index sp_hook_dbremote_end and sp_hook_ssrmt_end sp_hook_dbremote_receive_begin and sp_hook_ssrmt_receive_begin