Altering the state of a message in the sysmessages table. : sp_altermessage « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_altermessage

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