Addign Column to a replicated Table -- sql server replication

niv
6/14/2004 10:33:38 AM

Hello,
Is there a way to add a column to a replicated table
without deleting the subscription and recreating it?

Thanks,

niv
6/14/2004 11:18:35 AM

Paul,
Am I correct to assume that I will have to run this stored
procedure on both the publisher and the subscriber.

niv

[quoted text, click to view]

Paul Ibison
6/14/2004 7:02:48 PM

Niv,
have a look at sp_repladdcolumn in BOL.
HTH,
Paul Ibison

Paul Ibison
6/14/2004 7:28:29 PM

Niv,
just the publisher will do and synchronization will propagate it down to the
subscriber, and then update the relevant objects.
Regards,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Addign Column to a replicated Table