Use alter applied function replication definition and alter request function replication definition to alter the function replication definition to add new parameters, add new searchable parameters, or change the name of the destination stored procedure.
The syntax for the commands:
alter applied function replication definition
alter applied function replication definition function_applied_rep_def
{with replicate function named ‘proc_name‘ |
add @param_name datatype[, @param_name datatype]... |
add searchable parameters @param_name[, @param_name]... |
send standby {all | replication definition} parameters ...|
}[with DSI_suspended]
alter request function replication definition
alter request function replication definition function_request_rep_def
{with replicate function named ‘proc_name‘ |
add @param_name datatype[, @param_name datatype]... |
add searchable parameters @param_name[, @param_name]... |
send standby {all | replication definition} parameters ...|
}[with DSI_suspended]
These two commands are used to change the function replication definitions created by create applied function replication definition and create request function replication definition command respectively. See Replication Server Reference Manual > Replication Server Commands for more information about alter applied function replication definition and alter request function replication definition.
See Replication Server 15.6 Administration Guide Volume 2 > Pre-15.1 Request Function Replication to modify function replication definitions from versions of Replication Server earlier than 15.1.
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 applied and request functions.