CREATE PROCEDURE sp_hook_dbmlsync_set_extended_options ()
BEGIN
IF exists(SELECT * FROM #hook_dict
WHERE name LIKE 'subscription_%' AND value='sub1')
THEN
-- specify the SendColumnNames=on extended option
UPDATE #hook_dict
SET value = 'SendColumnNames=on'
WHERE name = 'extended options';
END IF;
END;