• Using SP_ALTER_MESSAGE.

    My test: setting is_logged_message from 1 to 0, but the message still be in ERRORLOG when certain event occurs. It's like SQL Server bypassed the change...

    Maybe there any exceptions, and my sample of messages isn't a good candidate to play thist test.

    []'s