-- Note:  If this was running in a DTS package, the process will show an error and you can view the message.
declare @ErrorMsg nvarchar(255)
set @ErrorMsg = 'Warning: You have exceeded the max value of: ' + convert(nvarchar(255), 500)
RAISERROR (@ErrorMsg, 16, 1)