x

log message - "setting database option COMPATABILITY-LEVEL to 100 for database..."

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!

more ▼

asked Aug 25, 2011 at 07:06 AM in Default

avatar image

colibri
151 15 15 17

Is it always the same database? What options are set for that database/the databases in question?

Aug 25, 2011 at 07:10 AM Magnus Ahlkvist
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 25, 2011 at 07:11 AM

avatar image

Kev Riley ♦♦
64k 48 61 81

yes this is a SSRS database... until we go to R2 I will try the workaround... thank you!

Aug 25, 2011 at 07:19 AM colibri
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x21
x11

asked: Aug 25, 2011 at 07:06 AM

Seen: 979 times

Last Updated: Aug 25, 2011 at 07:06 AM

Copyright 2016 Redgate Software. Privacy Policy