# MSSQL Query timeout
**URL:** https://www.finalbuilder.com/forums/t/mssql-query-timeout/902
**Category:** Discussion
**Created:** [July 15, 2008, 10:18am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902 "2008-07-15T10:18:33Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 15, 2008, 10:18am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902/1 "2008-07-15T10:18:33Z")
Hi
I have an [MSSQL Execute Query] object that query's a MSSQL server 2005 with the following script:
DECLARE @counter INT
SET @counter = 0
WHILE @counter = 0
BEGIN
SET @counter = 0
END
As you can see this is an indefinitely loop and i am looking for a way to stop it at a certain amount of time. I found the Query Timeout option and set it to 10 seconds, but it doesn't do a thing. The loop just keeps on going.
Any idea's how to stop the loop? Thx in advance.
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [July 16, 2008, 6:53am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902/2 "2008-07-16T06:53:57Z")
Hi,
It looks their was a bug in the SQL Execute Query action which was preventing the timeout from taking effect, here is a new build of FinalBuilder which correctly sets the query timeout:
FinalBuilder 6: [https://www.finalbuilder.com/downloads/finalbuilder/610/FB610\_841.exe](https://www.finalbuilder.com/downloads/finalbuilder/610/FB610_841.exe)
or
FinalBuilder 5: [https://www.finalbuilder.com/downloads/finalbuilder/550/FB550\_750.exe](https://www.finalbuilder.com/downloads/finalbuilder/550/FB550_750.exe)
Regards,
Paul.
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 16, 2008, 3:20am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902/3 "2008-07-16T03:20:51Z")
Hi again,
I downloaded and installed your build version 5, but the bug doesn't seem to be fixed. The loop just keeps on going and a time out never occurs. You are sure you tested it?
Thx
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [July 17, 2008, 2:04am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902/4 "2008-07-17T02:04:04Z")
Hi,
The bug where FinalBuilder was not passing in the correct timeout option to the underlying tool (SqlCmd, oSql, iSql) has definitely been fixed in build 750, so it looks like using a query timeout doesn’t work when the queries in an infinite loop.
I’m not sure why you would need to run an ‘infinite loop’ query, but as a workaround, could you perhaps do something like this?
DECLARE @counter INT
SET @counter = 0
WHILE @counter \< 10
BEGIN
SET @counter = @counter + 1
WaitFor Delay ‘00:00:01’
END
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 17, 2008, 9:41am UTC](https://www.finalbuilder.com/forums/t/mssql-query-timeout/902/5 "2008-07-17T09:41:31Z")
Normally we run another query, but sometimes that query gets in an infinity loop and to simulate this bigger query, i use a small loop. But i guess its time to try out the bigger query with a timeout value and see what happens.