SQL Server/T-SQL/System/sp altermessage

Материал из SQL эксперт
Перейти к: навигация, поиск

Using sp_altermessage

   <source lang="sql">

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

</source>