SQL Server/T-SQL Tutorial/System Functions/sp altermessage

Altering the state of a message in the sysmessages table.

4>
5> sp_addmessage 50001, 12, "The specified value for %s was invalid."
6>               , US_English, TRUE, REPLACE
7> GO
1> sp_altermessage 50001, WITH_LOG, FALSE
2> GO