Adding column to table

Just wanted to check. Running merge replication on SQL 2000. If I add a
column to a table that is a published article, I assume I just run
sp_repladdcolumn is that correct and is that all I need to do in order for
the laptops to get the change with their next synch? Also, what do I set
the value for @.force_reinit_subscription to? Thanks.
David
Yes. However I believe you need to set @.force_reinit_subscription and
@.force_invalidate_snapshot to 1.
Basically these switches will stop your script from working if they are set
to their defaults of 0. If you set them to 1 your scripts will run but you
may have to reinitialize your subscriptions.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23IOG4PPOHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Just wanted to check. Running merge replication on SQL 2000. If I add a
> column to a table that is a published article, I assume I just run
> sp_repladdcolumn is that correct and is that all I need to do in order for
> the laptops to get the change with their next synch? Also, what do I set
> the value for @.force_reinit_subscription to? Thanks.
> David
>