raiserror with nowait
snippet in sql

raiserror with nowait

user341

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