Tuesday, March 20, 2012

BIG PROBLEM : Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'

Anyone know my reports are all suddenly throwing this back :
Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'
?The Report Server uses two databases on SQL Server. One of them is called
ReportServerTempDB. It contains a table called ExecutionCache. Check out
whether this table is still there, and whether it can still be queried. You
have to use Enterprise Manager or Query Analyzer to try and query it.
HTH
Charles Kangak, MCT, MCDBA
"Matt Swift" wrote:
> Anyone know my reports are all suddenly throwing this back :
> Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'
> ?
>
>

No comments:

Post a Comment