InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:47:38 GMT20http://www.sqlservercentral.com/Forums/Topic1378446-391-1.aspxI was hoping for somethingbuilt-into SSMS like a query option or similiar but I will test both suggestions made.ThanksTue, 13 Nov 2012 12:09:47 GMTYSLGuruhttp://www.sqlservercentral.com/Forums/Topic1378446-391-1.aspxHave you tried replacing the While loop with a GO N?[code="sql"]SELECT *FROM MyTablewaitfor delay '00:00:02'GO 5[/code]Mon, 29 Oct 2012 15:27:18 GMTLuis Cazareshttp://www.sqlservercentral.com/Forums/Topic1378446-391-1.aspxyou can use a neat trick with RAISERROR to get an immediate result inside the loop, if that's what you want/need.a basic example:[code]--print error immediately in batchdeclare @i int, @err varchar(100)--set @i=1while 0=0beginSET @err = 'Progress So Far: Step ' + convert(varchar(30),ISNULL(@i,1)) + ' completed.'raiserror (@err,0,1) with nowaitwaitfor delay '00:00:02'set @i=ISNULL(@i,1) + 1end[/code]Mon, 29 Oct 2012 14:02:18 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1378446-391-1.aspxIs there a way in SSMS 2008 to get a query to execute every N seconds with a Wait For X seconds so that the query waits a few seocnds before each execution?I have a query that I have to press F5 for very 15 seconds or so and it would great if I could get the thing to auto run every X seconds for a maximum number of execiutions or for a maximum duration. I've managed to use the WIATFOR within a WHILE loop to do this but the query resulst are all shown after the Last executionj fo the loop and I'm trying to see the results as each execution of the query runs.The pseudocode would be something liike this:WHILE @iCOunter < 10 BEGIN SELECT X FROM TABLE WHERE Conditions SELECT @iCOunter = @iCOunter + 1ENDMake sense? Is this kind of thing possible in SSMS? ThanksMon, 29 Oct 2012 13:53:02 GMTYSLGuru