dbTalk Databases Forums  

Dropping and Creating of a Table.

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Dropping and Creating of a Table. in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brandon
 
Posts: n/a

Default 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?

Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default Re: Dropping and Creating of a Table. - 11-16-2004 , 03:12 PM






Brandon,
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.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.