Re: Replicating new table
From: Hilary Cotter (hilaryk_at_att.net)
Date: 08/05/04
- Next message: Hilary Cotter: "Re: sp_repladdcolumn on Indexed View"
- Previous message: Hilary Cotter: "Re: "Windows synchronisation manager profile" missing"
- In reply to: Jim: "Replicating new table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 5 Aug 2004 08:25:57 -0400
such a method would involve constantly polling the sysobjects and sysindexes
tables looking for a new table with a PK.
Then you would have to run sp_addarticle to add this table to your
publication.
Note that Log Shipping will do what you are looking for.
-- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html "Jim" <jim_beale@hotmail.com> wrote in message news:02e801c47a90$7c17a460$a301280a@phx.gbl... > Is it possible to have a newly-created table automatically > added to the list of published articles? If so, how? >
- Next message: Hilary Cotter: "Re: sp_repladdcolumn on Indexed View"
- Previous message: Hilary Cotter: "Re: "Windows synchronisation manager profile" missing"
- In reply to: Jim: "Replicating new table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
