Use sp_setrepproc to Copy User Stored Procedures

To copy the execution of a user stored procedure to the standby database, mark the stored procedure for replication with sp_setrepproc.

Procedures marked with sp_setrepproc are also reproduced at replicate databases if subscriptions have been created for them.

There are two possible scenarios for stored procedure execution in warm standby applications:

If you have marked the stored procedure for replication with sp_setrepproc, Replication Server copies execution of the procedure to the standby database. It does not copy the effects of the stored procedure to the standby database.
If you have not marked the stored procedure for replication, Replication Server copies DML changes effected by the procedure to the standby database, if the affected tables have been marked for replication.

See Replication Server Administration Guide Volume 1 > Manage Replicated Functions for more information about the sp_setrepproc system procedure.

If the database is the master database, user procedures are not replicated.