View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:25 PM
M Bourgon
 
Posts: n/a
Default SSMS - getting timeout terminated even with Execution time-out of 0?

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.
Thanks.

Reply With Quote