Cacher is the code snippet organizer for pro developers

This creates a user defined error, check to see if the error exists and the raises the error to see the message

exec sp_addmessage 50005, 16, N'This is a test essage!!!!'

select * from sys.messages

raiserror(50005,16,1)