Posted by Aaron Bertrand [SQL Server MVP] on 07/06/07 01:11

I think Mohit may be onto something here. Erland, are you trying on the
local server connection, or a remote query?






> Hm, what happens if you run:
>
> WAITFOR DELAY '00:11:00'
>
> do you get the timeout error?
>
> I don't, and I did not expect too. However, in order to verify that theh
> error message really comes from SSMS, I changed the timeout setting in
> SSMS to 30 seconds, and ran a WAITFOR for one minute. Which completed
> successfully. And just like you I opened a new query window and even
> restarted SSMS. I have tried re-booting my machine, though.
>
> Maybe there is some weired bug that makes it difficult to change the
> query timeout. But I would like you to try the WAITFOR statement, so
> that I know that I have a good test case.

• Next in forum: Re: How can I combine different rows?
• Prev in forum: Re: SSMS - getting timeout terminated even with Execution time-out of 0?
• Thread view: Re: SSMS - getting timeout terminated even with Execution time-out of 0?

[Reply to this message]