Hi, I have question regarding to add new articles. Right now I start snapshot
agent every time in order to replicate new table and relavant data into
subscription after I add new articles. I monitor replication and found it
seems like it re-transfer all articles into subscriber ...

starting with a transactional publication, the latency of a PUSH subscription
can be improved from ~1 hr (for ~100K transactions = ~700K commands) to less
than 5 minutes by setting the SubscriptionStreams parameter to 32 ---
however, making the same parameter change for a PULL ...

I am setting up merge replication in SQL 2000 (SP4), and the initial snapshot
has been taken successfully.
I then setup a push subscription; and when it tries to apply the snapshot it
comes back with the following error:

SQL Server 2005 SP2
I am trying to setup transactional replication but getting error
Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27
Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for