November 7, 2001 at 11:51 am
Hi,
I have a bidirectional transactional replication setup with queued updating subscription. Now I want to change a schema of one table which is being replicated. When I try to do that through replication wizard, it gives me error - 21381 saying that "Cannot add (drop) column to table 'xyz' because the table belongs to publication(s) with an active updatable subscription. What should I do?
AmitM
AmitM
November 7, 2001 at 2:23 pm
You will have to make the change manually. Easiest way is to drop the affected articles from the publication, make the change on both publisher and subscriber, then add the article back. See if this article will help:
http://www.sqlservercentral.com/columnists/awarren/alterreplicatedtable.asp
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply