SQL Informational Event Logging in Application Log

Posted on 2011-10-19
Last Modified: 2012-05-12
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?
Question by:meade470
    LVL 3

    Accepted Solution


    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.
    LVL 2

    Author Comment

    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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now