Temporary objects (tables, views, procedures) are not cleaned up from databases upon report compilation.
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.
To delete the temporary objects, run the relevant query (according to your SQL version) from this location <DVD_root>\InTrust\Tools\Database CleanUp.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy