Unless otherwise stated, the following conditions apply to event-hook procedures:

The #hook_dict table is created immediately before a hook is called using the following CREATE statement:

CREATE TABLE #hook_dict(
NAME VARCHAR(128) NOT NULL UNIQUE,
value VARCHAR(255) NOT NULL );

The SQL Remote Message Agent uses the #hook_dict table to pass values to hook functions; hook functions use the #hook_dict table to pass values back to the SQL Remote Message Agent.