SQL Server: PRINT output doesn't appear immediately
Solution 1:
No. Output of PRINT statements will only be returned when a transaction is committed, when other record sets are returned or a statement is completed (go statement terminator in a SQL batch). You can use raiserror at non-fatal error levels (0-18) to get immediate feedback of this sort. For example:
RAISERROR ('Foo', 10, 1) WITH NOWAIT