I figured it out. Thanks



>>>Try adding dbo. in front of the view name. Could it be that you don't have select permissions on this view (which would be quite strange)?
>>>
>>>Right click on the view, do script select and try running it separately.
>>
>>I have permissions. Script->Select worked fine
>
>Not sure then - I'll ask a question later, right now it's time for my favorite serial.