Return
-
Title
How to delete the temporary objects from the database -
Description
Temporary objects (tables, views, procedures) are not cleaned up from databases upon report compilation.
-
Cause
May be caused by known issuee CR0186374
When you manually stop a reporting job that is running, temporary objects related to reports the job has generated before termination may be not always automatically removed from MS SQL Reporting Services server and you may have to clean them up later. -
Resolution
To delete the temporary objects, run the relevant query (according to your SQL version) from this location <DVD_root>\InTrust\Tools\Database CleanUp.