Contents Index sp_hook_dbremote_begin and sp_hook_ssrmt_begin sp_hook_dbremote_shutdown and sp_hook_ssrmt_shutdown

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

sp_hook_dbremote_end and sp_hook_ssrmt_end


Function 

Use this stored procedure to add custom actions just before the Message Agent exits.

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
exit code integer A non-zero exit code indicates an error.
Description 

If a procedure of this name exists, it is called as the last event before the Message Agent shuts down.


Contents Index sp_hook_dbremote_begin and sp_hook_ssrmt_begin sp_hook_dbremote_shutdown and sp_hook_ssrmt_shutdown