Chapter 12: Managing Replicated Objects Using Multisite Availability
Replicating user stored
procedures
To
replicate user stored procedures, mark each procedure individually
using sp_setrepproc. Database replication
definitions do not check for owner information for user stored procedures.