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
Post a Comment