Add new column to a replicated table.. - 02-16-2005 , 07:47 AM
I need to add a column to a table that is being replicated.
Can I just do the ALTER TABLE ADD xxxx bit then make a call out to
When I do so, the sp fails saying the column exists. The manual says that it
adds the column to the publications, but does not suggest it does the
physical add tot the table..
Thanks in advance,
Re: Add new column to a replicated table.. - 02-16-2005 , 07:53 AM
You use sp_replAddColumn INSTEAD of using alter table add column.... the Sp
adds the column to the table, and fixes replication... since you manually
added the column the sp fails..... drop the column and use the SP only.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
"SPG" <steve.nospoo.goodsell (AT) nopooblueyonder (DOT) co.nopoo.uk> wrote
Re: Add new column to a replicated table.. - 02-16-2005 , 08:03 AM
Thanks for that..
I sort of half guessed that when the sp failed, but the docs are not too
clear on this..
"Wayne Snyder" <wayne.nospam.snyder (AT) mariner-usa (DOT) com> wrote