SQL Remote User's Guide
Utilities and Options Reference
The following stored procedure names and arguments provide the interface for customizing synchronization at SQL Remote databases.
Unless otherwise stated, the following apply to event-hook procedures:
The stored procedures must either have DBA authority ( Adaptive Server Anywhere ) or dbo authority (Adaptive Server Enterprise).
The procedure must not commit or rollback operations, or perform any action that performs an implicit commit. The actions of the procedure are automatically committed by the calling application.
You can troubleshoot the hooks by turning on the Message Agent verbose mode.
The hooks for dbremote and ssremote differ only in name.
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