Re: Change QueryTimeout

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hilary,

Thanks for this information, as I am having the same problem. I was able to
change my query timeouts by updating the msdb database. A question I have
though is what causes the queries to begin running longer? When I first
began this publication, I had no problems completing the replication query.
But over time, I have now encountered this problem.

I am assuming that it is due to a build up of changes that have occurred
overtime. And if that is the case, is there a way to reduce the change
history that the query must process?

"Hilary Cotter" wrote:

That's for the conflict viewer, when it logs on to the Publisher.

If you are getting prompted for the username and password it is because you
are using SQL authentication, switch to NT if possible. You should be able
to change querytimeout on the default profile. By default its 300s. Try to
use a new profile with the value you want, or modify it in the msdb
database.

--
Hilary Cotter
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

"David Chase" <dlchase@xxxxxxxxxxxxxxx> wrote in message
news:%23hRHTkeHGHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
So what is the query timeout in the View Conflicts button for? This shows
90 seconds.

Also, I cannot get to agent properties because the subscribers are
anonymous laptops. I get prompted for username and password but still
does not connect.

David

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OPeON6WHGHA.3728@xxxxxxxxxxxxxxxxxxxxxxx
Connect to your publisher in EM, expand the replication Monitor folder,
expand the distribution or merge agent folder, right click on your
problem agent, and select agent properties, click the steps tab, and
double click on run agent, click in the command text box, and press end,
then press space and type -QueryTimeOut 300 (or more).

--
Hilary Cotter
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

"David Chase" <dlchase@xxxxxxxxxxxxxxx> wrote in message
news:OWe$wyUHGHA.1676@xxxxxxxxxxxxxxxxxxxxxxx
How do I change the value in QueryTimeout? I have some wireless laptops
that are timing out sometimes when they synch. Thanks.

David








.

Relevant Pages

  • Re: Generate Snapshot
    ... You can query the table in the distribution database. ... where agent_id is the merge agent you are interested in. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: problem with merge replication
    ... Right click on the agent, select agent properties, select steps, double ... Looking for a SQL Server replication book? ... The merge process failed to execute a query because the query timed out. ... Could you tell me how I can increase the query timeout for the process? ...
    (microsoft.public.sqlserver.replication)
  • Re: Need Help Understanding How To Make This Work
    ... recordset consisting of a subset of the matching database record, ... The query on the table ... AgentName, in the record has a null value. ... In my program, I must first look to see if a record exists that matches the Firstname and Lastname of a client; then, I must look to see if an Agent is assigned to the client already. ...
    (comp.databases.ms-access)
  • Re: Delete records with only Name and Date filled in
    ... there is a query attached to the form. ... Agent column in the query and the source for CallDate is the CallDate column ... It appears that you are calculating the values and assigning them to the ...
    (microsoft.public.access.formscoding)
  • Re: Submitting is easy once you stop thinking about it
    ... > letter to send out another query. ... > it is now common practice for authors to send out multiple queries. ... > always happy to offer a quick professional peek and response (a.k.a. ... Same question with an agent. ...
    (rec.arts.sf.composition)