SQL Informational Event Logging in Application Log

We have a WebSense log server that logs all activity that is being filtered through the appliance, and it is logging the following event to the application log every minute:

(We are running Sql Server 2008 Express R2 on a Windows 2003 server)

Type:      Information
Source:      MSSQLSERVER
Event ID:      9724
Event Time:      10/19/2011 10:38:00 AM
User:      n/a
Computer:      LK-WEBSENSELOG2
The activated proc '[dbo].[usp_sb_run_scheduled_job]' running on queue 'wslogdb70.dbo.wse_scheduled_job_queue' output the following:  'Caution: Changing any part of an object name could break scripts and stored procedures.'

What can we do to squelch this event log message and stop it from populating in the Application log?
Who is Participating?

it is just an informational message as you are changing the names of objects.
Looks like [dbo].[usp_sb_run_scheduled_job] is trying to change name of objects in the process.
If you can look in to the procedure code then look for string "sp_rename"  that will explain.

Vinod Pottekkatt.
meade470Author Commented:
We are aware that it is a informational message, but it is bloating our Application log and limiting the length of time we can look back in Application logging.

Is there a workaround\procedure to disable this informational message?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.