I have a Database which is Merge Replicated to 5 sites

I need to add 1 new field

What is the best way of doing this ?

I have previously removed the publications, subscribers, added the
field and pushed the whole database out

Please advise

Regards Paul

paulg@wizardit.co.uk (paul goldney) wrote in message news:<dda7c881.0408082311.183c39@posting.google.co m>...
> I have a Database which is Merge Replicated to 5 sites
>
> I need to add 1 new field
>
> What is the best way of doing this ?
>
> I have previously removed the publications, subscribers, added the
> field and pushed the whole database out
>
> Please advise
>
> Regards Paul

When you say "add a new field", I guess you mean "add a new column to
an existing table"? You can make the change with the replication
interface in Enterprise Manager, and it will be replicated for you -
see "Schema Changes on Publication Databases" in Books Online.

Simon

"paul goldney" <paulg@wizardit.co.uk> wrote in message
news:dda7c881.0408082311.183c39@posting.google.com ...
> I have a Database which is Merge Replicated to 5 sites
>
> I need to add 1 new field
>
> What is the best way of doing this ?
>
> I have previously removed the publications, subscribers, added the
> field and pushed the whole database out


Check out sp_repladdcolumn.

>
> Please advise
>
> Regards Paul