Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SSRS - Report History is still maintained even after deleting the report from Report Manager

Jan 31 2012 12:00AM by Dattatrey Sindol (Datta)   

Reporting Services has a system database called "ReportServer" (default) which it uses to store the information related to reports, data sources, report execution etc. stored/accessed on the Report Server.

A table called "Catalog" stores the information related to various objects hosted on the Report Server like Reports, Linked Reports, Data Sources etc. A table called "ExecutionLogStorage" stores the information related to execution/generation of reports etc.

When a report is added to Report Server, an entry will be made into "Catalog" table and when it is executed, an entry is made into "ExecutionLogStorage" table. Interestingly, when a report is deleted from the Report Server, the entry from "Catalog" table is deleted but the entry in the "ExecutionLogStorage" table is still retained.

Use the following query to verify it on your own.

SELECT *
FROM ExecutionLogStorage
WHERE ReportID NOT IN (SELECT ItemID FROM Catalog WHERE Type = 2)

Note: Table names are as per the SSRS 2008 version.

Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Dattatrey Sindol (Datta)
42 · 4% · 1336
10
 
2
 
 
0
Incorrect
 
 
0
Forgotten



Submit

1  Comments  

  • To the Admins:

    Please Please Please fix your site so that the emails come from webmaster@beyond.... and not make it look like the person that is posting the comment. Otherwise it will get confused as junk mail from an unknown person.

    commented on Jan 31 2012 7:20AM
    mbova407
    322 · 0% · 132

Your Comment


Sign Up or Login to post a comment.

"SSRS - Report History is still maintained even after deleting the report from Report Manager" rated 5 out of 5 by 10 readers
SSRS - Report History is still maintained even after deleting the report from Report Manager , 5.0 out of 5 based on 10 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]