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 copies DML changes effected by the procedure to the standby database, if the affected tables have been marked for replication.
See Chapter 10, “Managing Replicated Functions” in the Replication Server Administration Guide Volume 1 for more information about the sp_setrepproc system procedure.
If the database is the master database, user procedures are not replicated.
