SELECT  *
FROM    sys.messages
WHERE   language_id = 1033
        AND (
              is_event_logged = 1
              OR severity >= 19
            )
ORDER BY message_id;

DECLARE @message_id INT = 8134;

EXEC sys.sp_altermessage 
    @message_id = @message_id,
    @parameter = 'WITH_LOG',
    @parameter_value = 'TRUE';