"Mike" <Mike@discussions.microsoft.com> wrote in message
news:E58CEE1E-B55D-4DB3-8E4F-1AB5387C36F2@microsoft.com...
> Thanks Raymond. Where will I see immediate_sync property.
>
> "Raymond Mak [MSFT]" wrote:
>
>> Hi Mike,
>>
>> You shouldn't need to reinitialize your existing subscription in order to
>> get snapshot data for the new article propagated to the subscriber. And
>> if
>> you have a transactional publication with the immediate_sync property set
>> to
>> false, the snapshot agent will only generate bcp data for the new
>> article.
>>
>> -Raymond
>> "Mike" <Mike@discussions.microsoft.com> wrote in message
>> news:43347180-986E-474C-8C45-EB83BEB62DE5@microsoft.com...
>> > Hi:
>> >
>> > I have a publication with larger sql table articles. I want to add
>> > another
>> > article (small table). To start replicating, I will need to
>> > reinitialize
>> > and
>> > rerun the snaphot. I don't want to run the snapshot during the day
>> > time
>> > because it may block other users because publication has some large
>> > tables
>> > in
>> > it.
>> >
>> > Is there anyway that I can replicate just that table to subsriber
>> > during
>> > the
>> > day time?
>> >
>> > Thanks a lot
>> >
>>
>>
>>