Phil, not sure I understand the question. When I branch and then open the branched solution the reference are there, however they are invalid. It's almost like these reference are...

Actually there is a similar question below with a screenshot to make it clearer. However there is no answer there

https://social.msdn.microsoft.com/Forums/en-US/5c9c5c47-64ac-4af4-9104-c9500dc8cf52/ssdt-schema-compare-keeps-showing-the-same-objects-as-different?forum=ssdt

Properties are under each SP and, other objects for that matter, on the schema compare page. It looks something like

> Procedure ...

I've hit the error on both trying to install the assembly and running the CLR once the assembly is loaded and I've switched the Trustworthy property OFF. I've also tried...

Ok I've managed to get this performing reasonably well with a combination of changes. I've kept the 3 queries separate as I wasn't getting anywhere combining them in a single...

OK it turns out this does work. It's just taking an age to return the plan.

I stopped my testharness which had been running on the same query overnight

Ran DBCC freeproccache

Ran...