"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23LaKKLZ3FHA.1596@tk2msftngp13.phx.gbl...
> With SQL 2000 a mini snapshot only containing the newly added table will
> be generated and distributed.
>
> --
> 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
>
> "Troy" <manuel@pushit.com> wrote in message
> news:ucDzNCZ3FHA.3400@tk2msftngp13.phx.gbl...
>> hello,
>>
>> I'm unclear about certain aspects of replication and maybe somebody can
>> help. I have sql 2000 servers all aroound and currently running
>> transaction replication to replicate a database to a reporting server. If
>> I add a table to the publisher and modify the piblication to include the
>> new article will that table show up at the subscriber or do I have to
>> invoke the snapshot agent? If I restart the snapshot agent will it start
>> to copy all the data? the DB is about 600GB so little hesitant about
>> doing this. Also, as far as stored procedure execution is concerned
>> what's the best way to handle that? Any help is appreciated.
>>
>> thanks
>>
>>
>
>

"Troy" <manuel@pushit.com> wrote in message
news:ucDzNCZ3FHA.3400@tk2msftngp13.phx.gbl...
> hello,
>
> I'm unclear about certain aspects of replication and maybe somebody can
> help. I have sql 2000 servers all aroound and currently running
> transaction replication to replicate a database to a reporting server. If
> I add a table to the publisher and modify the piblication to include the
> new article will that table show up at the subscriber or do I have to
> invoke the snapshot agent? If I restart the snapshot agent will it start
> to copy all the data? the DB is about 600GB so little hesitant about doing
> this. Also, as far as stored procedure execution is concerned what's the
> best way to handle that? Any help is appreciated.
>
> thanks
>
>