I am getting an overwhelming amount of messages in my error log everyday stating, "setting database option COMPATABILITY-LEVEL to 100 for database [ db_name]" How can I stop these messages? They don't seem to be crtical but are filling up my log file and making it difficult to find more important messages. Thanks!
asked Aug 25, 2011 at 07:06 AM in Default
Is this on a SSRS database?
If so it seems from this Connect item, that it was fixed in 2008R2
There also seems to be a [potential workaround here], where you change the service account.: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/474f0c72-95b0-4fe3-8f3c-b7b7e500bd4f