Re: Add new table to sql server 2005 transaction replication

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hilary,

I have used the sp_addarticle, and sp_refreshSubscriptions succesfully.

sp_addarticle
@publication = RYS_SPRS77_PUBL,
@article = InstrumentCheckResult,
@source_object = InstrumentCheckResult

sp_refreshsubscriptions
@publication = RYS_SPRS77_PUBL

However, when I checked the ReplicationMonitor

I see message: The initial snapshot for article InstrumrntCheckResult is not
yet available
Do I still need to run the snapshot agent again?

Thanks,
--
George Gopie



"Hilary Cotter" wrote:

Use sp_addarticle for this. If it is a pull subscription you will need to do
a sp_refreshsubscriptions

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"georgeg" <ggg@xxxxxxxxxxx> wrote in message
news:5D774662-3B4D-4B58-9091-36F05F8CDB46@xxxxxxxxxxxxxxxx
I am trying to add a new table to tansaction replication on sql server
2005.
The problem I am having is that if I restrt the snapshot agent, it is
doing
all the tables in the publisher. Ho can I make the snapshot agent do only
the
new table?

Steps I have taken:

1. Add new table to publisher and the publication.
2. Star the snapshot agent

This is all done using the SSMS Gui.

Thanks,
--
George Gopie




.