Hi Team, I m working with audit trace i have created one sp & Job for this we have using this in security env 3rd party tool, but in that toll we are validating them we are getting error called ' Invalide object name 'Execution Log', Can you any body please suggest me. When can we get Execution Log Error ? i google in SSReporting Servers only we will get that error, in that toll also generating a Report any idea really appeareciate those guys.. Txsubu

Hi, Can you check existence of below views/table on ReportServer database - ExecutionLog - ExecutionLog2 (on 2008 and 2008 R2 only ) - ExecutionLog3 ( on 2008 R2 only) You can use this query on your report server dv select * from sys.all_objects where name like 'Execution%' If you do not find these views, you can copy the definition from some other (test, Dev) server having same SQL server edition and create it on this box. - Chintak (My Blog)

Hi Chintak, Thanks for your reply... name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date is_ms_shipped is_published is_schema_published ExecutionLog 213575799 NULL 1 0 U USER_TABLE 2012-08-31 15:52:32.767 2012-08-31 15:53:45.923 0 0 0 i want drop this table becuses i dont know what is the db name can you pelase provide script for this. Txsubu

Hi subu, The report server execution log contains information about the reports that execute on the server. We can use the report execution log to find out how often a report is requested, what output formats are used the most, and how many milliseconds of processing time is spent on each processing phase. The report execution log is stored in the views of the report server database that by default is named ReportServer. In this issue, the error may occur if the execution log name is typed by mistake. At this time, I suggest that you search the query and make sure the execution log name is "ExecutionLog" other thant "Execution Log". If you rarely use the ExecutionLog, you can disable it from the SQL Server Management Studio and remove it. For more information, please see: Report Server Execution Log Regards, Mike YinMike Yin TechNet Community Support

Hi subu, The report server execution log contains information about the reports that execute on the server. We can use the report execution log to find out how often a report is requested, what output formats are used the most, and how many milliseconds of processing time is spent on each processing phase. The report execution log is stored in the views of the report server database that by default is named ReportServer. In this issue, the error may occur if the execution log name is typed by mistake. At this time, I suggest that you search the query and make sure the execution log name is "ExecutionLog" other thant "Execution Log". If you rarely use the ExecutionLog, you can disable it from the SQL Server Management Studio and remove it. For more information, please see: Report Server Execution Log Regards, Mike YinMike Yin TechNet Community Support