Adding new column in published table

hi,
I wish to add a new column in published table. i know using
sp_repladdcolumn we can add columns. but i wish to know using
sp_repladdcolumn is better or drop the replication then add the column and
recreate the replication is better.
Can anyone suggest the right way ?
Thanks in advance
Petchikumar."Petchikumar" schrieb:
> hi,
> I wish to add a new column in published table. i know using
> sp_repladdcolumn we can add columns. but i wish to know using
> sp_repladdcolumn is better or drop the replication then add the column and
> recreate the replication is better.
> Can anyone suggest the right way ?
> Thanks in advance
> Petchikumar.
Both ways are correct. sp_repladdcolumn (with reinitialization of the
subscribers) will be a little quicker as you save the time of dropping the
replication ...