Check out sp_mergearticlecolumn in SQL Server Books Online. This stored
procedure allows you to vertically partition out or add back a column to a
merge replication published table.
Hope this helps,
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Joseph" wrote:
> Hi Guys;
>
> What proc would I use to add an existing column to an existing merge
> publication?
>
> I realize that an entire reinitialization will have to take place :(
>
> I've looked at options on sp_ReplAddColumn, and I've looked at the one
> that changes properties on a publication, but neither seems to fit the
> bill, and I've run out of leads...
>
> Thanks!
>
> Joseph
>
Thanks, Tom!
[quoted text, click to view] On Feb 27, 2:00 am, Tom <T...@discussions.microsoft.com> wrote:
> Check out sp_mergearticlecolumn in SQL Server Books Online. This stored
> procedure allows you to vertically partition out or add back a column to a
> merge replication published table.
>
> Hope this helps,
> Tom
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
> "Joseph" wrote:
> > Hi Guys;
>
> > What proc would I use to add an existing column to an existing merge
> > publication?
>
> > I realize that an entire reinitialization will have to take place :(
>
> > I've looked at options on sp_ReplAddColumn, and I've looked at the one
> > that changes properties on a publication, but neither seems to fit the
> > bill, and I've run out of leads...
>
> > Thanks!
>
> > Joseph- Hide quoted text -
>