In addition to replicating data-changing operations, another way to maintain consistent, synchronized data is to replicate the invocation of stored procedures that change data. Replicating a stored procedure invocation can sometimes be more efficient than replicating the individual data-changing operations that the procedure produces.
When a stored procedure is published, the replication system must identify the procedure and record the input parameter values that are specified when the procedure is invoked. The system must then distribute that procedure invocation to any subscribing replicate database.
Stored procedure replication places a special requirement on a replication system. When a published procedure generates a data-changing operation on a published table, the replication system must be able to recognize the operation generated by the published procedure, and replicate only the procedure invocation and not the data-changing operation produced by it.
