To add new parameters, add new searchable parameters, or change the name of the destination stored procedure, use alter function replication definition to alter the function replication definition. The syntax for this command is:
alter function replication definition function_rep_def
{deliver as proc_name |
add @parameter datatype[, @parameter
datatype]... |
add searchable parameters @parameter
[, @parameter]... |
send standby {all | replication definition}
parameters}
The options for alter function replication definition are similar to those for create function replication definition. Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for more information about alter function replication definition command.
See “Creating or modifying a function string for a replicated function” for information about function strings for function replication definitions.
To add new searchable parameters to the where clause of a define subscription command, drop and re-create the subscription for the function replication definition. For more information about subscribing to function replication definitions, see “Implementing an applied function”.
