Add column to a merge article.

Hi, I need to add a new column to a table that is an
article in a merge replication. I know how to do that in
enterprise manager, but i need to add this new column in
the table primary key. I try to do it but it seem that i
have to remove the replication, do the changes and then
configure the replication again.
Do you know if i can do this changes without removing the
replication? Could you explain me how?
Thanks a lot for your help.
have you tried sp_repladdcolumn?
"maria" <mariaisabelguzman@.icasa.com.gt> wrote in message
news:f7d501c4135a$1e0f9aa0$a001280a@.phx.gbl...
> Hi, I need to add a new column to a table that is an
> article in a merge replication. I know how to do that in
> enterprise manager, but i need to add this new column in
> the table primary key. I try to do it but it seem that i
> have to remove the replication, do the changes and then
> configure the replication again.
> Do you know if i can do this changes without removing the
> replication? Could you explain me how?
> Thanks a lot for your help.
>
|||Sp_repladdcolumn is valid for SQL Server 2000. If you have SQL Server 7.0,
you must drop the subscriptions and publication before adding the column.
Regards,
Shirley
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. 2001 Microsoft Corporation. All rights
reserved.