Cacher is the code snippet organizer for pro developers

SET @msgdate = @rundate 
RAISERROR ('Processing %s', 0, 1,@msgdate ) WITH NOWAIT

--Custom Error Messages 
 
--To add new custom message... 
sys.sp_addmessage 
 
--To see all messages 
SELECT * FROM sys.messages m