InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:31:38 GMT20http://www.sqlservercentral.com/Forums/Topic716467-1547-1.aspxDoesn't work on 2008r2, getting Msg 8152, Level 16, State 13, Procedure Upd_RSExecutionLog, Line 108String or binary data would be truncated.Sat, 20 Nov 2010 19:53:07 GMTMaricopaJoehttp://www.sqlservercentral.com/Forums/Topic716467-1547-1.aspxI have also seen some duplicates. For me, the reason is because of this segment of code where we are inserting data into the RSExecutionLog table:INNER JOIN RSExecutionLog.dbo.Reports R WITH(NOLOCK) ON C.Name COLLATE Latin1_General_CI_AS = R.Name AND C.Path COLLATE Latin1_General_CI_AS = R.Path AND C.Type = R.ReportTypeHere, if you have 2 reports with the same name, but they have different cases, the report execution will get added twice. For example, I had a report called "dept activity report.rdl". I then changed it to "Dept Activity Report.rdl". Both report names get added to the reports table, and therefore 1 report execution gets added twice into the RSExecutionLog table. To fix this, I just changed the above code to: INNER JOIN RSExecutionLog.dbo.Reports R WITH(NOLOCK) ON c.ItemID = r.ReportIDIt seems like this works fine.ChrisMon, 11 Oct 2010 09:40:19 GMTchris.o.smithhttp://www.sqlservercentral.com/Forums/Topic716467-1547-1.aspxDoes this SP apply to SQL Server 2008?Thu, 10 Sep 2009 09:39:57 GMTeric.bookbinderhttp://www.sqlservercentral.com/Forums/Topic716467-1547-1.aspxThanks for the stored procedure. I seem to have some duplicates in my ExecutionLogs table though. Has anyone else had a problem like this.Wed, 24 Jun 2009 05:59:55 GMTbabreu417http://www.sqlservercentral.com/Forums/Topic716467-1547-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/RSExecutionLog/66858/">Stored Procedure to maintain RSExecutionLog</A>[/B]Wed, 13 May 2009 15:04:46 GMTPerry Dyball