Replication of procedures

Any replication system is faced with a choice between two options when replicating a stored procedure call:

  • Replicate the procedure call   A corresponding procedure is executed at the replicate site, or

  • Replicate the procedure actions   The individual actions (INSERTs, UPDATEs, DELETEs, and so on) of the procedure are replicated.

SQL Remote replicates procedures by replicating the actions of a procedure. The procedure call is not replicated.