Thank you for the question Steve.

Slightly off topic, prefer using RAISERROR to PRINT for progress reporting on long running scripts as it is almost instant and the printf functionality is very handy.

RAISERROR ('This is %s message number %d!', 0, 0 ,'my',123) WITH NOWAIT;

😎