You may use stored procedure replication to encapsulate complex DML operations or those affecting a large number of rows. Stored procedure replication improves performance by replicating only the call to the stored procedure and ignoring modifications to individual rows. Network traffic is decreased and Replication Server needs less processing to apply the stored procedure at the replicate site.
In warm standby configurations that replicate DDL, select into operations cannot be replicated as they are minimally logged. Stored procedure replication cannot be used because of transaction management restrictions inherent to replication processing and to the select into command.
Additionally, some third-party applications cannot be easily modified to support replication of stored procedures. Consequently, even though stored procedure replication improves Replication Server performance, it cannot be used in all circumstances.
