sp_hook_dbremote_message

sp_hook_dbremote_message_missing

Use this stored procedure to perform actions when the SQL Remote Message Agent has determined that one or more messages is missing from a remote user.

Rows in #hook_dict

Name	Values
remote user	The name of the remote user who will have to resend messages.

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_missing

Rows in #hook_dict

Privileges