|
|
Posted by Erland Sommarskog on 07/05/07 22:56
M Bourgon (bourgon@gmail.com) writes:
> On SSMS 9.00.3042.00, any query that runs longer than 10 minutes gets
> the following error message:
>
> The statement has been terminated.
> 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 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.
>
> Any suggestions? I'm using QA to get around this for now, but this
> seems a pretty basic issue.
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.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|