Include the with_log option in sp_altermessage to change an existing user-defined message. This parameter alters the reporting status of that message:
TRUE – to enable logging
FALSE – to disable logging
