Hairbrush
asked on
Reporting Services keeps writing application event log entries every few seconds
On my Vista 64 development PC, every 5-10 seconds a new application event log is being written:
"Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer$SQL2008."
"Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer$SQL2008TempDB ."
As you might imagine, my application event log is full of these messages! Any ideas what is causing this?
"Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer$SQL2008."
"Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer$SQL2008TempDB
As you might imagine, my application event log is full of these messages! Any ideas what is causing this?
ASKER
Good idea, thanks. From Profiler I can see that every 5 seconds, SQL Server is being sent the following:
DECLARE @currVer nvarchar(128), @currMajorVer nvarchar(32), @idx int, @currMajorVerInt tinyint ;
SELECT @currVer = CONVERT(nvarchar(128), ServerProperty('ProductVer sion')) ;
SET @idx = CHARINDEX('.', @currVer, 0) ;
SET @currMajorVer = SUBSTRING(@currVer, 1, @idx-1) ;
SET @currMajorVerInt = CONVERT(tinyint, @currMajorVer) ;
DECLARE @dbname sysname
IF @currMajorVerInt = 10
BEGIN
SELECT @dbname=DB_NAME()
EXEC sp_dbcmptlevel @dbname, 100 ;
END
USE [ReportServer$SQL2008TempD B]
IF @currMajorVerInt = 10
BEGIN
SELECT @dbname=DB_NAME()
EXEC sp_dbcmptlevel @dbname, 100 ;
END
USE [ReportServer$SQL2008]
When I stop Reporting Services, the events stop appearing, so it's definitely down to that... question is - why does it keep calling this?!
DECLARE @currVer nvarchar(128), @currMajorVer nvarchar(32), @idx int, @currMajorVerInt tinyint ;
SELECT @currVer = CONVERT(nvarchar(128), ServerProperty('ProductVer
SET @idx = CHARINDEX('.', @currVer, 0) ;
SET @currMajorVer = SUBSTRING(@currVer, 1, @idx-1) ;
SET @currMajorVerInt = CONVERT(tinyint, @currMajorVer) ;
DECLARE @dbname sysname
IF @currMajorVerInt = 10
BEGIN
SELECT @dbname=DB_NAME()
EXEC sp_dbcmptlevel @dbname, 100 ;
END
USE [ReportServer$SQL2008TempD
IF @currMajorVerInt = 10
BEGIN
SELECT @dbname=DB_NAME()
EXEC sp_dbcmptlevel @dbname, 100 ;
END
USE [ReportServer$SQL2008]
When I stop Reporting Services, the events stop appearing, so it's definitely down to that... question is - why does it keep calling this?!
I've no idea....it might be a quirk inside reporting services 2008 that they haven't fixed yet. Is the ApplicationName field in your profile Reporting Services?
ASKER
Yes. In profiler, application Name = "Report Server". It is an "out of the box" installation of the Developer Edition, so I would have thought if it was a bug that affected everyone, there would be lots of blog postings about it on the web - even if there was no fix yet.
I found quite a few postings on it just from your description...even the one posted on the MSDN forums didn't have an answer....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks CGLuttrell. Changing the start up logon from Network Service to Local System certainly does the trick - I would be happier knowing what the cause was and if the change has any undesired effects, but I won't lose any sleep over it! Thanks for your help.
http://www.phwinfo.com/forum/ms-sqlserver-server/346049-sql-2008-reportserver-growing-3-5gb-huuge.html