Just because I'm not actively posting doesn't mean I'm not still monitoring 🙂

Smart, thanks for that. Only took 7 years to get a reasonable answer:-D

Apparently Microsoft has no plans to fix this

https://connect.microsoft.com/SQLServer/feedback/details/700197/ssis-catalog-doesnt-have-option-to-give-read-access-to-ssis-catalog-to-view-package-run-reports

This Stack link has an alternate workaround

http://dba.stackexchange.com/questions/78341/permission-to-view-execution-report-in-ssis-catalog

thank you

I've never seen any way to implement it in a relational database without a junction table.

Even the Wikipedia definition includes the statement "...it is necessary to implement such relationships physically...

I realize this is very old, but this is still unanswered. Anyone know the solution to this?

Ignore this topic. There was a type-o which caused the issue.

Please delete post.

I just checked all the servers that we've received the error from and here are the version numbers...

SQL 2012 - 11.0.3000

SQL 2008 R2 - 10.50.4000

My fix to this was just to replace the FROM statement that has the ranking function with the original FROM statement. I know it was probably a bug fix,...

I captured the query that is causing the issue and ran it individually so I could get the statistics IO and the actual execution plan.

Here is the query I ran...

Yeah, it is doing a scan. I don't want to touch it because it's a Microsoft database schema. I'd like to know how to report this in if...

Ok, no one got back to me on this and I was finally able to pinpoint the problem. It's definitely an issue with SQL Server 2012's version of the...

Thanks for that. I guess I can chalk this up to some kind of disk latency issue?

This is exactly how it came in (with the exception of me renaming actual application DBs to DB1, DB2, etc...)

2012-09-18 00:00:47.870 spid20s This instance of...

None, I copied and pasted the message exactly as it was in the log.