CODE EXAMPLE FOR SQL

raiserror with nowait

-- Show a message immediately to the Messages box.
RAISERROR ('Now that''s what I call a message!', 0, 1) WITH NOWAIT