MS SQL Server - Adding new column in published table

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Adding new column in published table

Petchikumar

2005-06-30, 3:23 am

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.

Christian Donner

2005-06-30, 7:23 am

"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 ...

Sponsored Links