<ytu@creativelabs.com> wrote:

>Sue,
>
>Thank you for your response. The remote query timeout is
>0 which means unlimited. Usually, the timeout message
>pops up within 1 minutes when I or user run the query.
>Thanks.
>
>Yuling
>>-----Original Message-----
>>Did you check the remote query timeout settings? The
>default
>>is 600 (on 2000 anyway, can't remember what it is with 7)
>>which is 10 mins. You could try increasing that value.
>>
>>-Sue
>>
>>On Thu, 20 Nov 2003 11:46:28 -0800, "Yuling"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>Hi,
>>>
>>>We have SQL 7 and 2000 servers and I create link server
>>>on each machine respectively.
>>>
>>>I use openquery to get data from each machine by
>creating
>>>a view. Somehow, I will get timeout frequently by
>query
>>>the view at SQL 7 (which use openquery to get data from
>>>SQL 2000). But, I don't have this issue at SQL 2000
>>>(using openquery to get data from SQL 7).
>>>
>>>There is no timeout setting on both machines and the
>link
>>>server setting is about the same at both machine. How
>>>can I solve this issue in SQL 7? (We use those view to
>>>run some report).
>>>
>>>Thank you for your help.
>>>Yuling
>>
>>.
>>