sp_altermessage is back in business!

Just a quick note that we again can modify whether system messages are to go to eventlog/errorlog again. I.e., we can change the is_event_logged column in sys.messages. This is very valuable in general and specifically is you want to define Agent alerts (for which Agent polls the Eventlog). For instance:

SELECT * FROM sys.messages
WHERE message_id = 1205
AND language_id = 1033

Notice the value for the is_event_logged column. Now, run below:

EXEC sp_altermessage
 @message_id = 1205
,@parameter = ‘WITH_LOG’
,@parameter_value = ‘true’

Now, re-run the select statement and see that you modified the behavior for the system message. Now, re-run the sp_altermessage with ‘false’ to reset to default.

The ability to modify this behavior for system messages was available prior to SQL Server 2005, but some re-architecturing in 2005 removed the functionality. kozloski informed me in this blog post that 2005 sp3 re-introduced the functionality and obviously as of sp1 the functionlity is back in 2008 as well.

 

7 Replies to “sp_altermessage is back in business!”

  1. Bet188link, đường dẫn mới của 188bet hả? Mấy cái link này hay bị chặn lắm, phải có cái dự phòng thế này mới yên tâm được. Thanks for sharing bet188link.

  2. I switched from another platform and honestly I can not go back. The registration process was a breeze and the daily tournaments keep things exciting. You really need to experience trbet10casino for your own self.

  3. This platform really stands out because of its incredible game selection and smooth gameplay mechanics. I appreciate how they regularly update their slots and table games to keep things exciting. The payout speed is also impressive compared to other sites I have used. It is my go to spot for weekend entertainment. cobetssonjuegos

  4. This platform really knows how to treat its regulars. Loyalty rewards stack up quickly and cashouts go through without annoying paperwork. Seriously consider vn3wing for your next session

Leave a Reply

Your email address will not be published. Required fields are marked *