How do I publish an alteration to a replicated stored procedure (SQL 2000)?

Question

We have several stored procedures marked as articles for replication in our SQL2000 database. If we update any of them via ALTER PROCEDURE, the changes are applied to the master, but never published to subscribers. Am I missing a setting, or does SQL require a complete reinitialization/snapshot to move the changes out?

Answer 1

Here are two ways to update the stored procedure on master and subscribers

• Drop the replication article on the stored procedure, and recreate it
• Use the sp_addscriptexec stored procedure to replicate then execute a script containing the alter procedure command on the master and all subscribers

Source: http://www.replicationanswers.com/General.asp