sql server - Clear SSRS cache with SQL code -


to solve problem - ssrs shows wrong form tried clear ssrs cache. 1 post suggested use sql - http://social.msdn.microsoft.com/forums/sqlserver/en-us/58caa380-ece8-4507-9ff3-684c93685e72/how-to-clear-a-report-cache-in-ssrs-2008?forum=sqlreportingservices

the code -

use reportserver exec flushreportfromcache @path exec cleanexpiredcache 

@path need give path report need clear cache.

which path enter here ? entered folder contains rdlc files , sql gave me 0 rows returned. doing simple beginner exercises on local system.

this path report want clear cache. can querying dbo.catalog table in reportserver database follows:

use reportserver; go  select  name     --<-- report name       ,[path]    --<-- report path [dbo].[catalog]   go 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -