>>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.