?
Solved

SQL Informational Event Logging in Application Log

Posted on 2011-10-19
2
Medium Priority
?
1,688 Views
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
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?
0
Comment
Question by:meade470
2 Comments
 
LVL 3

Accepted Solution

by:
pg_vinod earned 2000 total points
ID: 36995031
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
 
LVL 2

Author Comment

by:meade470
ID: 36995050
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

839 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