You can adjust the schedule of the job running the agent. I'm guessing that the agent is running continuously. If you change it to run every 5
minutes or so, it will automatically restart itself when errors occur.
The parameters for each agent profile are documented in SQL Server Books OnLine. Look at the topic "Merge Agent Profile".
Increasing the Query Timeout parameter is a workaround, but won't solve the actual problem. "Timeout Expired" messages are normally
related to network connectivity problems between the distributor and subscriber. It's also possible that there is a performance issue on one
of those machines and the agent cannot complete its task within the Query Timeout value you've specified.
Shirley Kelly, MCSE, MCDBA
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit