sp_hook_dbremote

sp_hook_dbremote_shutdown

Function

Use this stored procedure to initiate a Message Agent shutdown.

Rows in #hook_dict table

Name	Values	Description
send	true or false	Indicates if the process is performing the send phase of replication.
receive	true or false	Indicates if the process is performing the receive phase of replication
shutdown	true or false	This row is false when the procedure is called. If the procedure updates the row to true the Message Agent is shut down.

Description

If a procedure of this name exists, it is called when the Message Agent is neither sending nor receiving messages, and permits a hook-initiated shutdown of the Message Agent.

Send feedback about this page via email or DocCommentXchange