Posted by Erland Sommarskog on 10/05/83 11:26

Mike (mjorlando@campsystems.com) writes:
> When I researched how prevent SQL Server from logging this type of
> message, I found that I can use sp_update_alert to disable this
> message, but I cannot find
> the message_id to correctly disable this message. In sysmessages, the
> message I am trying to suppress is
> error:18265 severity:10 dlevel:128 description:Log backed up:
> Database:
> %1, creation date(time): %2(%3), first LSN: %4, last LSN: %5, number of
> dump devices: %7!d!, device information: (%8). mslangid:1033
>
> I tried calling sp_update_alert as follows:
>
> exec sp_update_alert @name = 'Log backed up: Database: %1, creation
> date(time): %2(%3), first LSN: %4, last LSN: %5, number of dump
> devices: %7!d!, device information: (%8).', @enabled = 0

Look in msdb..sysalerts. You should find the message there. If you don't,
I suppose that sp_update_alert is not your guy after all.
--
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

• Next in forum: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
• Prev in forum: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
• Thread view: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

[Reply to this message]