Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The error log on my sql server throws this warning every 5 seconds

'Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.'

From what I can tell this may be due to my environment having a mix of 2005 and 2008 SQL Servers, with linked servers between them and reports that pull from each, but I am not sure exactly what this message means.

Is this message warning me of a problem? If so how do I resolve the underlying issue. If not, how do I get this message to stop flooding my error logs.

share|improve this question
up vote 1 down vote accepted

We get this as well in our SSRS 2008 environment (although luckily only once a day). Apparently it is a known bug, but will not affect the functionality of Reporting Services.

From Microsoft: "Thanks for posting this issue to me. We have fixed this bug in SQL Server 2008 R2 CTP2 but we decided not fix it in SQL Server 2008 due to concerns of breaking backward compatibility. Thanks again for the feedbacks."

share|improve this answer

If you run a trace (SQL Server Profiler), you can confirm the bug.

DECLARE @currVer           nvarchar(128) 
        , @currMajorVer    nvarchar(32) 
        , @idx             int 
        , @currMajorVerInt tinyint; 

SELECT @currVer = CONVERT(nvarchar(128), ServerProperty('ProductVersion')); 

SET @idx = CHARINDEX('.', @currVer, 0); 
SET @currMajorVer = SUBSTRING(@currVer, 1, @idx - 1); 
SET @currMajorVerInt = CONVERT(tinyint, @currMajorVer); 

DECLARE @dbname sysname 

IF @currMajorVerInt = 10 
      SELECT @dbname = DB_NAME() 

      EXEC sp_dbcmptlevel 

USE [ReportServerTempDB] 

IF @currMajorVerInt = 10 
      SELECT @dbname = DB_NAME() 

      EXEC sp_dbcmptlevel 

USE [ReportServer]

You can also confirm the 12-hour restart behaviour is as per default installation settings:


Specifies a recycle time for the application domain, measured in minutes. Valid values range from 0 to maximum integer. The default is 720.

No further action is required, unless you consider the merits of changing the RecycleTime.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.