Include the with_log option in sp_altermessage to change an existing user-defined message.
TRUE – to enable logging.
FALSE – to disable logging.