sp_hook_dbremote_message_apply

sp_hook_dbremote_message_apply_begin

Use this stored procedure to perform actions just before the SQL Remote Message Agent applies a set of messages from a user.

Rows in #hook_dict

Name	Values
remote user	The name of the remote user who sent the messages about to be applied.

Hook procedures can be created by any user with the MANAGE REPLICATION system privilege. However, to ensure that the hook can access the #hook_dict table, which is used to pass information in and out of hooks, hooks must meet one of the following requirements:

Be owned by a user with the SELECT ANY TABLE and UPDATE ANY TABLE system privileges.
Be defined using the SQL SECURITY INVOKER clause of the CREATE PROCEDURE statement.

Discuss this page in DocCommentXchange.

sp_hook_dbremote_message_apply_begin

Rows in #hook_dict

Privileges