May 6, 2008 at 10:25 am
Hi All,
I have run into a very annoying issue which i just cannot seem to get round. For the last few weeks i have been running queries against a remote server which have taken 40/50 minutes without any issue. Now all of a sudden the query times out after 10 minutes every time.
The first thing i checked was the remote query timeout, that is set to 0 (and has not been changed). The SSMS settings are 0 (default) so it shouldnt be that timing out.
The error message i receive is...
Msg -2, Level 11, State 0, Line 0
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I ran sp_configure on the remote server and received the following row...
remote query timeout (s)0214748364700
This seems to support my thinking that there is no remote query timeout configured.
I have done some tests doing
select '1'
waitfor delay '00:10:01'
select '2'
and this also times out after 10 minutes.
Im out of ideas, i have restarted SSMS, restarted the server, restarted my machine, and nothing has made any difference.
How something like this can just start happening is beyond me :crazy:
May 6, 2008 at 10:27 am
It is also probably worth noting that i just ran a quick test against another server using the waitfor test and that also timed out after 10 minutes.
So my conclusion is that it MUST be SSMS related, and not server specific.
So i would be very grateful if someone could help me out, computers drive me mad sometimes.
May 7, 2008 at 7:03 am
this problem seems to be solved. I rebooted again today and now its magically all working again :w00t:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply