sql server replication: sp_repladdcolumn behavior with large table -- sql server replication

sp_repladdcolumn behavior with large table

Brian K
1/12/2006 3:06:17 PM

sql server replication: I have a replicated database that needs a column added to a table with
approximately 3.5 million rows. Will it re-synch the entire table to the
subscribers when I add the column with sp_repladdcolumn, or simply just
add the column?

IE, will I be looking at replicating 3.5 million rows to my subscribers
over 64k data line?

Re: sp_repladdcolumn behavior with large table

Hilary Cotter
1/12/2006 10:00:53 PM

just add the column, not the data, you will have to follow it with an
update of this column to the data you wish to put in it.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]