all groups > sql server replication > july 2004 >
You're in the

sql server replication

group:

adding fields


adding fields larry
7/30/2004 10:32:04 AM
sql server replication: Win 2K & SQL 2K

I have several SQL servers replicating to one server and
I need to add a field to a replicated table can I.....

Add the field to the subscriber, then via the Properties-
[quoted text, click to view]
to the publisher??

Will this cause a problem with the other publishers when
they attempt to replicate and there is an addition al
field in the destination table, but has not been added on
all the publishers??

Logically, this seems like it will work. I really do not
want to drop all the publications, alter the tables, then
recreate all the publications with no sync.

Re: adding fields Hilary Cotter
7/30/2004 3:47:29 PM
the preferred way to add a column to articles in an existing publication is
to use sp_repladdcolumn.



--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

AddThis Social Bookmark Button