I am running SQL Server 2000, and have successfully configured Transactional replication using Enerprise Manager.
The problem I am having is that the network connection between the Publisher and Subscriber is quite tempromental. It seems that if the connection goes down for a period of time, I get the error message "The process could not connect to subscriber". The problem is that even when the connection is back up again I have to manually "Start Synchronizing".
Is there any way using Enterprise manager GUI to make sure the agent continues to attempt to replicate the date? Or Will I have to write some kind of service to Kick start the agent?
thanks in advance