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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-18 : 09:21:14
Bhama writes "We have SQL 2000 Database in Corporate office which is replicated to other 5 stores. We use Merge replication. After upgrading the server from SQL 7 to SQL 2000 the replication has got a lot easier. But I am having one particular problem each time I rebuild the replication.

Even though I disable the merge agents and snapshot agents, they start automatically based on their schedule interval. Since our database is quite huge with over 150 tables, its better to start one snapshot agent at a time manually. But they all start running even if disable and I get error messages. How can I disable them when I rebuild replication????

I disable the job and the schedule of the job also.

Thanks
Bhama."
   

- Advertisement -