add column to updateable subscription

sql2k sp3
Ive got a Publication with a Subscription that is
Immediate Updating with Queued for Failover. I tried to
run sp_repladdcolumn and got:
Server: Msg 21381, Level 16, State 1, Procedure
sp_repldropcolumn, Line 277
Cannot add (drop) column to table 'transdtl' because the
table belongs to publication(s) with an active updatable
subscription. Set @.force_reinit_subscription to 1 to force
reinitialization.
Server: Msg 21284, Level 16, State 1, Procedure
sp_repldropcolumn, Line 637
Failed to drop column 'test' from table 'transdtl'.
So how do you gurus add a column in this scenario? Do I
actually need to re snapshot the table? The only other
option I can think of would be:
Add them to the tables without sp_repladdcolumn. Add them
as an Article. Generate the Procs and Triggers for them.
Hmmm. That would suck.
TIA, Chris
I take it you are dropping a column. Your post is a little unclear to me.
do a sp_repdropcolumn with @.force_invaldiate_snapshot=1,
@.force_reinit_subscription=1
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:76ea01c47679$327475b0$a601280a@.phx.gbl...
> sql2k sp3
> Ive got a Publication with a Subscription that is
> Immediate Updating with Queued for Failover. I tried to
> run sp_repladdcolumn and got:
> Server: Msg 21381, Level 16, State 1, Procedure
> sp_repldropcolumn, Line 277
> Cannot add (drop) column to table 'transdtl' because the
> table belongs to publication(s) with an active updatable
> subscription. Set @.force_reinit_subscription to 1 to force
> reinitialization.
> Server: Msg 21284, Level 16, State 1, Procedure
> sp_repldropcolumn, Line 637
> Failed to drop column 'test' from table 'transdtl'.
>
> So how do you gurus add a column in this scenario? Do I
> actually need to re snapshot the table? The only other
> option I can think of would be:
> Add them to the tables without sp_repladdcolumn. Add them
> as an Article. Generate the Procs and Triggers for them.
> Hmmm. That would suck.
>
> TIA, Chris