RAISERROR( 'This message will show up right away...',0,1) WITH NOWAIT
Example…
-- Inside loop
print 'loop end:' + CONVERT(VARCHAR(50),@i)
RAISERROR( 'loop end',0,1) WITH NOWAIT
Sources:
https://stackoverflow.com/questions/306945/how-do-i-flush-the-print-buffer-in-tsql
Comments