Modifying a function replication definition

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. See 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.