sql server replication: Hi,

Is there a way where I can add a table to an existing publication in SQL
2000 (both publisher and subscriber) and get the transactional replication
to work without generating the snapshot of the whole database ? There are
few tables who have columns omitted from the existing publication but added
manually on both publisher and subscriber. So, if I add this new table and
have to generate a snapshot of the complete database, it will break the
application as the omitted columns will not be included in the snapshot. Any
help will be much appreciated

Thanking you in anticipation,

Yoga

Yes - just add the new article then run the snapshot agent and only the new
table will get snapshotted:

exec sp_addarticle @publication = 'tTestFNames'
, @article = 'tEmployees'
, @source_table = 'tEmployees'

exec sp_addsubscription @publication = 'tTestFNames'
, @article = 'tEmployees'
, @subscriber = 'RSCOMPUTER'
, @destination_db = 'testrep'

HTH,