Need to add informative progress messages

[EitanBlumin]

Add RAISERROR(...) WITH NOWAIT commands between checks to informatively track progress.
This should be part of the check templates.