all groups > sql server replication > february 2007 >
You're in the

sql server replication

group:

Merge Repl: Adding existing column


Merge Repl: Adding existing column Joseph
2/26/2007 1:18:35 PM
sql server replication:
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
RE: Merge Repl: Adding existing column Tom
2/27/2007 12:00:08 AM
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]
Re: Merge Repl: Adding existing column Joseph
2/27/2007 5:00:42 AM
Thanks, Tom!


[quoted text, click to view]

AddThis Social Bookmark Button