Mssql$Sophos in event logs

Question

I hope someone can help.

In my event logs on a windows server 2003 dc I am getting an informational message from Mssql$Sophos about every 5 minutes and it is filling the logs. Here is the message :

Event Type: Information
Event Source: MSSQL$SOPHOS
Event Category: (2)
Event ID: 2803
Date:  02/08/2010
Time:  12:36:48
User:  N/A
Computer: Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

What i want to know is is there any way of stopping the message from appearing atall or atleast less frequent.

Thanks in advance

Gareth

This thread was automatically locked due to age.

lilhavoc · Accepted Answer

Hi Gareth,

This wouldn't happen to be a database that was upgraded to SQL Server 2005 Express, would it?

The following command should switch off auto-close - you don't mention which version of Enterprise Console is installed, so if you are running 4.5, please change sophos4 to sophos45:

osql -E -S .\sophos -d sophos4 -Q "alter database sophos4 set auto_close off" 
 
 To confirm that auto-close option is set to off: osql -E -S .\sophos -d sophos4 -Q "exec sp_dboption @dbname='sophos4', @optname='autoclose'"

Cheers, 
 Lil

:4338