Using sp_altermessage : sp_altermessage « System « SQL Server / T-SQL

1. SQL Server / T-SQL
2. System
3. 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

 

Related examples in the same category