Dropping and Creating of a Table. - 11-16-2004 , 02:49 PM
I have what, hopefully, is a simple question. Do any of the methods
of replication for SQL 2000 support the dropping and creating of a
table and have it replicated to the remote system?
Re: Dropping and Creating of a Table. - 11-16-2004 , 03:12 PM
I'm assuming you're talking about an existing publication. In transactional
this is possible using sp_addarticle, sp_addsubscription,
sp_refreshsubscriptions and the corresponding drop commands for the
converse. As far as I recall, snapshot also behaves this way but not merge.
I'll test this when I get a moment.
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: