>-----Original Message-----
>What are those caveats Hilary that a snapshot would be
run again for all
>articles ? Also I believe when you drop certain columns
too using
>sp_repddropcolumn the whole subscription needs to be
reinitialised.. Am i
>right ? If so , can you mention the caveats there too...
>
>"Hilary Cotter" <hilaryk@att.net> wrote in message
>news:uyet14AoDHA.2444@TK2MSFTNGP09.phx.gbl...
>> You can add articles and drop articles without having
to drop the
>> subscriptions.
>>
>> There is a caveat for doing this with some forms of
transactional
>> replication in that the snapshot must be run again, but
for most forms of
>> transactional and merge replication the entire snapshot
does not have to
>be
>> run again. A mini snapshot will be run for the new
article and its
>related
>> metadata.
>> "Brett" <anonymous@discussions.microsoft.com> wrote in
message
>> news:00c301c39fe7$953ab420$a601280a@phx.gbl...
>> > Hello...
>> >
>> > I want to add an article to my publication. Do I
need to
>> > drop subscriptions to my publication in order to add
an
>> > article? If not, can I add the article and push only
>> > those articles that I added to my subscribers?
>> >
>> > I am using transactional replication. My publisher,
>> > distributer and subscriber are all SQL Server 2000.
>> >
>> > Please advise..
>> >
>> > Thanks,
>> > Brett
>> >
>>
>>
>
>
>.