Right click on the agent, select agent properties, select steps, double
click on run agent, and at the end of the command string type -QueryTimeOut
600
--
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pingx" wrote in message
> Hi,
> I ran an update query on the publisher.
> When I start the merge agent manually, I got the following error after a
> while.
>
> The merge process failed to execute a query because the query timed out.
> If
> this failure continues, increase the query timeout for the process. When
> troubleshooting, restart the synchronization with verbose history logging
> and
> specify an output file to which to write
>
> Could you tell me how I can increase the query timeout for the process?
> The replication is not moving now.
>
> Thanks in advance.
>
> Pingx
>