SQL Server Performance

Transactional Replication

Discussion in 'SQL Server 2005 Replication' started by chetana, Oct 16, 2007.

  1. chetana New Member

    I implemented Transactional replication (with immediate updating subscribers) between two sql 2005 servers. The server has got one database and this entire database has to be replicated to the other server. First i created the publication by selecting all the tables and store procs on the master server
    Then i ran the script of DB and created a subscription on the subscriber .
    It seems i got the data from the publisher but along with it i also got a few more tables like dbo_conflict_publicationame_table name for all the tables. How to get rid of these unwanted tables
    secondly, if i create a new table how to replicate it ..how to add it to the existing publication..does it automatically get added?
  2. techbabu303 New Member

  3. satya Moderator

  4. ghemant Moderator

Share This Page