Posted by Erland Sommarskog on 09/15/05 00:13

Mike (mjorlando@campsystems.com) writes:
> I agree, sp_update_alert is not the answer. I actually checked the
> sysalerts table and only found 10 rows in this table. None matched the
> message which I'm trying to suppress. Since I'm looking for a
> message_id, I also tried calling sp_altermessage 17055, 'WITH_LOG',
> 'false' using the event ID 17055 found in the Windows Event Viewer and
> also tried with 18265, which is the first part of the event
> description, but no luck. Any other suggestions? Thanks.

Since I don't know this stuff myself very well, I asked in our internal MVP
forum, and Jasper Smith who I trust to know this very well told me that
there is no way to prevent the logging to event log.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]