sp_hook_dbremote_receive_end system procedure

Use this system procedure to perform actions after the end of the receive phase of replication.

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_receive_end system procedure

Rows in #hook_dict

Privileges