Replication: Adding a column

Hi,
I have a table that is being replicated but one the the developers added a
column to the table WITHOUT using sp_repladdcolumn. Now, they are wondering
why this column is not on the subscriber. What is the easiest way to solve
this problem? (I am thinking of changing the subscription and adding the
column to the subscription and doing a snapshot but I hate to do this as it
takes a while on a 15 GB database).
Any fast way of solving this WITHOUT removing the column on the publisher?
--
I saw it work in a cartoon once so I am pretty sure I can do it.I would sp_dropScubscription/ sp_droparticle/
sp_addarticle/ start the snapshot agent.
Make sure that the sp_dropsubscription specifies that
article only. Do this first in Dev.
>--Original Message--
>Hi,
>I have a table that is being replicated but one the the
developers added a
>column to the table WITHOUT using sp_repladdcolumn. Now,
they are wondering
>why this column is not on the subscriber. What is the
easiest way to solve
>this problem? (I am thinking of changing the
subscription and adding the
>column to the subscription and doing a snapshot but I
hate to do this as it
>takes a while on a 15 GB database).
>Any fast way of solving this WITHOUT removing the
column on the publisher?
>--
>I saw it work in a cartoon once so I am pretty sure I
can do it.
>.
>