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
Showing posts with label altering. Show all posts
Showing posts with label altering. Show all posts
Monday, February 20, 2012
Merge Replication and altering tables
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?
ThanksRobert,
if you use sp_repladdcolumn on the publisher, it will propagate to the
subscriber.
Regards,
Paul Ibison
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?
ThanksRobert,
if you use sp_repladdcolumn on the publisher, it will propagate to the
subscriber.
Regards,
Paul Ibison
Merge Replication and altering tables
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?
ThanksRobert,
if you use sp_repladdcolumn on the publisher, it will propagate to the
subscriber.
Regards,
Paul Ibison
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?
ThanksRobert,
if you use sp_repladdcolumn on the publisher, it will propagate to the
subscriber.
Regards,
Paul Ibison
Subscribe to:
Posts (Atom)