Re: REPLICATION ERROR - retention-based meta data

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

Hi Paul,

I want to increase query timeout value but I don't how to do this. Please
advise me how to change timeout value. Is it possible to set this for a
particular database?

Thanks,
Soura.

"Paul Ibison" wrote:

> SouRa,
> in your case I'd like to know if this solves the issue so I'd set it to an
> extremely big number - just to see if the error still occurs.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>
>
>
.

Relevant Pages

  • Re: Need Query For Enforce relationship fo replication
    ... Soura ... > I keep a list of this type of query at ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem in BACKUP job
    ... Soura. ... > Please try using RESTORE VERIFYONLY on your dodgy backup file - it might be ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2000 query time out option, what does it do?
    ... > Can anyone tell me what the query time out is for? ... The query timeout is for queries to remote servers. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Inserted row after DB_E_ABORTLIMITREACHED
    ... A query timeout means that the API got tired of waiting for results ... API you use. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • RE: Query Timeout
    ... There is an option in replication job to change the ... "Herbert" wrote: ... >> I want to increase query timeout value but I don't know how to do this. ... >> Soura. ...
    (microsoft.public.sqlserver.replication)