Groups | Blog | Home
all groups > sql server replication > august 2005 >

sql server replication : Alter table in transactional Replication


Paul Ibison
8/19/2005 12:00:00 AM
You can use sp_repladdcolumn.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

SQL Replication Guy
8/19/2005 8:34:25 AM
I have a table that is being used in transactional replication. On publisher
side table is altered and a column is added. I would want the new column also
to be replicated.

Here is what i did-
- drop the subscription
- remove article from publication
- add back article
- modify insert update stored procedures at subscriber
- add the subscription

Is there any other way to do it as I donot want my subscription to be
dropped each time as it has some other tables that are replicated
continuously...

Regards,
Ravi

AddThis Social Bookmark Button