Hello,
Is there a way to add a column to a replicated table
without deleting the subscription and recreating it?
Thanks,
niv
Niv,
have a look at sp_repladdcolumn in BOL.
HTH,
Paul Ibison
|||Paul,
Am I correct to assume that I will have to run this stored
procedure on both the publisher and the subscriber.
niv
>--Original Message--
>Niv,
>have a look at sp_repladdcolumn in BOL.
>HTH,
>Paul Ibison
>
>.
>
|||Niv,
just the publisher will do and synchronization will propagate it down to the
subscriber, and then update the relevant objects.
Regards,
Paul Ibison
Tuesday, March 20, 2012
Addign Column to a replicated Table
Labels:
addign,
column,
database,
deleting,
microsoft,
mysql,
oracle,
recreating,
replicated,
server,
sql,
subscription,
table,
tablewithout
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment