Stop Using PRINT to Track Query Progress

Stop using PRINT. Start using RAISERROR.

PRINT

PRINT 'One.' 
WAITFOR DELAY '00:00:05'; 
 
PRINT 'Two.' 
WAITFOR DELAY '00:00:05';

PRINT with GO

PRINT 'One.' 
GO
WAITFOR DELAY '00:00:05'; 
 
PRINT 'Two.' 
GO
WAITFOR DELAY '00:00:05';

RAISEERROR with NOWAIT

RAISERROR('One.', 0, 1) WITH NOWAIT;
WAITFOR DELAY '00:00:05';
 
RAISERROR('Two.', 0, 1) WITH NOWAIT;
WAITFOR DELAY '00:00:05';

Source:

Stop Using PRINT to Track Query Progress