A procedure can be configured to act as a replication source using the ALTER PROCEDURE statement.
The following statement makes the procedure MyProc act as a replication source.
ALTER PROCEDURE MyProc REPLICATE ON;
The following statement prevents the procedure MyProc from acting as a replication source.
ALTER PROCEDURE MyProc REPLICATE OFF;
You can also use the sp_setreplicate or sp_setrepproc system procedures to set up procedures for replication.
When a procedure is used as a replication data source, calling the procedure sends extra information to the transaction log.