Contents Index SQL Remote options sp_hook_dbremote_begin and sp_hook_ssrmt_begin

SQL Remote User's Guide
  Utilities and Options Reference

SQL Remote event-hook procedures


The following stored procedure names and arguments provide the interface for customizing synchronization at SQL Remote databases.

Notes 

Unless otherwise stated, the following apply to event-hook procedures:

The #hook_dict table  

The #hook_dict table is created immediately before a hook is called using the following CREATE statement:

CREATE table #hook_dict(
name VARCHAR(128) NOT NULL UNIQUE,
value VARCHAR(255) NOT NULL )

The Message Agent uses the #hook_dict table to pass values to hook functions; hook functions use the #hook_dict table to pass values back to the Message Agent.


sp_hook_dbremote_begin and sp_hook_ssrmt_begin
sp_hook_dbremote_end and sp_hook_ssrmt_end
sp_hook_dbremote_shutdown and sp_hook_ssrmt_shutdown
sp_hook_dbremote_receive_begin and sp_hook_ssrmt_receive_begin
sp_hook_dbremote_receive_end and sp_hook_ssrmt_receive_end
sp_hook_dbremote_send_begin and sp_hook_ssrmt_send_begin
sp_hook_dbremote_send_end and sp_hook_ssrmt_send_end
sp_hook_dbremote_message_sent and sp_hook_ssrmt_message_sent
sp_hook_dbremote_message_missing and sp_hook_ssrmt_message_missing
sp_hook_dbremote_message_apply_begin and sp_hook_ssrmt_message_apply_begin
sp_hook_dbremote_message_apply_end and sp_hook_ssrmt_message _apply_end

Contents Index SQL Remote options sp_hook_dbremote_begin and sp_hook_ssrmt_begin