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
Description:
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?
LVL 2
meade470Asked:
Who is Participating?
 
pg_vinodCommented:
Hi,

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.

Thanks
Vinod Pottekkatt.
 
 
0
 
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?
0
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.