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

Altering the state of a message in the sysmessages table.

   <source lang="sql">

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</source>