Silly Question about Studio Express

[Fhwqhgads]

I have Microsoft SQL Server Management Studio Express

Is there a way to see output/messages while a process is running?

For example, if I type
declare @count smallint
set @count = 1
While @count < 1000
Begin
Select @count
Set @count = @count + 1
END

The "1,2,3..." do not show up until the entire query is finished, and then they show up all at one time.
How do I get output to be displayed as the process is going?

Thanks!

 

[mrdenny]

You can't. The GUI will return data to the screen as it can. It doesn't return it in real time. If you use the command line tool sqlcmd it will return the output in real time.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com