SQL Server/T-SQL/System/sp altermessage

Using sp_altermessage

 

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