I started trying to figure out how to start and stop the replication
agent for my transactional publication. What I found that I could do
was the following to stop the agent
WHERE dest_db='myDB' AND artid='1'
This seems to work, but I wanted to get feedback on the following
1. Is this an acceptable way to stop the transactional replication
2. How can I specify the subscription server along with the dest_db
in my select stmt?
3. Why is it that when I stop the first article all of the other
published articles stop their replication as well?
a. Note that I get an error indicating that the job is all ready
stopped if I try to stop the job for my other articles in the same
Thank you for your help in advance,