T-SQL Output Message During execution in SSMS

Question

I have a simple query which loops and I want to see the PRINT messages during the execution. The query is something like this:

WHILE 1 = 1 BEGIN     WAITFOR DELAY '000:00:10'     PRINT 'here' END 

The PRINT 'here' does not output until I stop the process. However, I want to see it while it's running. Is this possible?

Answer 1

You can use RAISERROR with serverity 0 and the NOWAIT option

WHILE 1 = 1 BEGIN     WAITFOR DELAY '000:00:10'     RAISERROR ('here', 0, 1) WITH NOWAIT END