Print immediately

The PRINT command doesn’t always print immediately in SSMS - sometimes it queues the messages up.

I’m sure there’s a reason, which I don’t care enough to research, but if you use this instead of PRINT, then you’ll always see the message right away.

raiserror('Message', 0, 1) with nowait;