Posted by Erland Sommarskog on 08/15/07 21:18

rcamarda (robert.a.camarda@gmail.com) writes:
> Thanks for the quick and flame free reply Erland. I did fail to
> mention the version of SQL I am using: SQL 2005.
> I found in Query > Query Options > Execution > General > Execution
> Time Out (currently set to 0 seconds).
> I'm guessing that if I set this to 600, my query would terminate at 10
> minutes if it didn't complete?

I guess that it's faster just to change and try, than wait for me to
answer. :-)

But I remember now that there was a weird bug with the query timeout in SSMS 2005. But it appears affects connections to the local server only. See
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=286298

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

• Next in forum: Re: Using sql to execute a batch file, xp_cmdshell
• Prev in forum: Re: standard and easy way to do schema design
• Thread view: Re: Limit query execution time

[Reply to this message]