Hi,

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
sp_replAddColumn?

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,

SPG

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
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"SPG" <steve.nospoo.goodsell (AT) nopooblueyonder (DOT) co.nopoo.uk> wrote

Thanks for that..
I sort of half guessed that when the sp failed, but the docs are not too
clear on this..

Steve
"Wayne Snyder" <wayne.nospam.snyder (AT) mariner-usa (DOT) com> wrote