Apart from the null problem you will not see any output
until the buffer is full. You can force this by printin a
large string to fill the buffer after your print.
>i have a long running operation (and one that would fill
up the tempdb), so
>i want to break it into smaller chunks, and PRINT my
>i run the query in Query ysier, and all i ever see is
> "(101 row(s) affected)"
>i never see my print output
>And it's happened in the past with other long-running
loop based ...