Replicating new table

Is it possible to have a newly-created table automatically
added to the list of published articles? If so, how?
Jim,
you'd have to manually run sp_addarticle (for snapshot and transactional,
followed by running the snapshot agent and synchronizing). Adding a table
involves inserts into syscolumns, sysobjects and various other tables in the
database catalog, but we can't add triggers onto such tables, so there is no
'automatic' process - it has to be done manually.
HTH
Paul Ibison
|||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?
>