Adding a column to a Replicated Table

Adding a column to a table being replicated can be a pain. Here’s a better way…

exec sp_repladdcolumn '[dbo].[table_name]','column_name',[varchar(200)], '%', '1'

to delete...
exec sp_repldropcolumn '[dbo].[survey]','sr_english_sur_id'

Just rebuild your snapshots and you're all set.

Advertisement