some useful stored procedures for creating replication scripts:


Note: not all these procedures were made by myself; I've added them here with permission of the authors. All procedures may be used on your own risk etc (#include default.disclaimer.

sp_gen_alterdef will generate scripts for altering replication definitions.

sp_gen_repdef will generate scripts for generating replication definitions.

sp_gen_repset will generate scripts that mark your tables for replication.

sp_gen_repsub will generate script for the subscriptions.