Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replicate Table additions and modifications

Author  Topic 

durilai
Starting Member

13 Posts

Posted - 2007-02-23 : 17:20:04
I am new at replication and it has been going well, but have more of an information question that a problem. Basically I have transactional replication without updates. So i am pushing from the publisher to the subscriber only. I have added a table to the publisher side, and it is not replicating to the subscriber. Data pushes fine. I have read about reinitializing, adding article, etc. I do not know which is the way to go, I need it to happen automatically.

Which way and how? Any help is appreciated greatly.

Thanks

durilai
Starting Member

13 Posts

Posted - 2007-02-25 : 21:17:48
Ok, I found that I need to run the snapshot agent to push the table changes to the subscriber. Now I am assuming I can schedule a job to run the snapshot agent. Can anyone help me to the correct stored procedures.

Thanks
Go to Top of Page
   

- Advertisement -