Drop one article from transaction publication without drop the

Hi ,
I have to delete large amount of data from a table that is one of many
articles in Transaction publication.
I want to dropt the specific article , delete the data and than add the
article again (initial the specific article only) In order to save
transfer the heavily transactions from the replication (~ 2 GB of data for
subscribers with bad connectivity)). Can I drop one article from
transaction publication without drop the subscribers first? (The whole
publication is very heavy - drop all subscribers , add it again and
reinitial all subscribers will take hours .)
BTW - is it possible in merge replication ?
Thanks,
Eyal
Eyal,
what you are requesting is not possible through the gui but is possible
through scripts. This sort of query should work for you:
exec sp_dropsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
exec sp_droparticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)