I have a couple of SQL 2000 servers that are using Merge replication and
need to alter a table. Can I alter a table on one and have that alteration
replicate, for example, if I change the field length or add an index?
If I add a column to a table, I assume that I would have to add that column
to the subscription, correct?
Thanks
Robert,
if you use sp_repladdcolumn on the publisher, it will propagate to the
subscriber.
Regards,
Paul Ibison
No comments:
Post a Comment