sp_hook_dbremote_message_apply

sp_hook_dbremote_message_apply_end

Use this stored procedure to perform actions just after the SQL Remote Message Agent has applied 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 that have been 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.

Discuter à propos de cette page dans DocCommentXchange.

sp_hook_dbremote_message_apply_end

Rows in #hook_dict

Privileges