The sp_altermessage system stored procedure is used to alter the state of an error message.
Syntax for the sp_altermessage System Stored Procedure
sp_altermessage [ @message_id = ] message_number ,
[ @parameter = ] 'write_to_log' ,
[ @parameter_value = ] 'value'
--Using sp_altermessage
sp_altermessage
60000,
'WITH_LOG',
'true'
GO
|