You are here: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log « MsSQL Server « IT news, forums, messages
Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

Posted by GP on 09/15/05 01:34

Erland Sommarskog wrote:
> 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.
>
>
This might be an obvious thing to look at, but have you tried this..?

1. Open the properties of the job.
2. Go to the Notifications tab.
3. Make sure that the "Write to the Windows Application Event Log"
option is un-checked.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация