Posted by M Bourgon on 07/06/07 21:59

On Jul 5, 5:56 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:

> > I have changed the setting for Execution time-out to 0 in Tools->
> > Options->Query Execution, but it's still happening - in new windows
> > and after having restarted SSMS.

> Hm, what happens if you run:
>
> WAITFOR DELAY '00:11:00'
>
> do you get the timeout error?

I do.
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.

Looking at what Mohit posted, my server does have the remote query
timeout of 600 seconds. But this is the first time I've ever seen
this issue. Odd.

Okay - this is odd - if I create a new Database Engine Query, it works
properly, even though (with the same instance of SSMS running) I
managed to have it timeout on me with the WAITFOR test.

So, is that why Query Analyzer doesn't get killed after 10 minutes?
Because it's a local connection?
Or did you just manage to create a bug separate from what I was
seeing?

[Back to original message]