RAISERROR (N'After 2', -- Message text 10, -- Severity 1) -- State WITH NOWAIT
The thing to note here is the use of NOWAIT option.
This flushes all waiting resultsets and messages back to the client.
Also note the use of non fatal severity and state, since we don’t
want to cancel our script but only inform the user of the progress.
It comes in very handy when running script that can take a while indeed.