I've added a column to an already transaction replicated article. Adding that column and not having to re-snapshot or reinitialize was a fun puzzle.
Running 'sp_scriptpublicationcustomprocs' shows the new column already apart of the replication stored procedures (sp_MSins,sp_MSdel,sp_MSupd).
My question is, is there an easier way to deploy these 'refreshed' sprocs (maybe via sproc) rather than copying and pasting from the output of 'sp_scriptpublicationcustomprocs'?
The whole point of this is to avoid re-snapshoting or re-initializing.
Thanks.