stored procedures can be replicated as any other article.
The things to remember are that we can't replicate system
tables, so the text of the stored proc (syscomments)
won't be replicated in the same way as normal user data.
This means that if the procedure changes, it won't be
picked up by the replication process. As they are treated
in a different way, and a new snapshot might be needed on
a regular basis, you might want to place the stored procs
in a separate publication. This is how I set things up,
with a post-snapshot script to be run which adds the
Another aspect of replicating stored procedures is that
transactional replication will give you the option to
replicate the EXECUTION of the stored procedure as well
as the procedure itself.
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: