sql server replication: add column to updateable subscription -- sql server replication

add column to updateable subscription

ChrisR
7/30/2004 2:07:18 PM

sql server replication:

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.

Re: add column to updateable subscription

Hilary Cotter
8/2/2004 8:35:04 AM

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

[quoted text, click to view]