I try it with the View designer and I can just access remote tables. I don't have access to any local tables or views. When I try it with the command window, the error UNKNOWN OBJECT occurs.


>It is possible that UPSIZE could not handle converting your local view to a remote view but it would be possible to have the same view as a remote.
>
>Try creating one manually from the view designer and see it it helps.
>Kamal
>
>>I tried to upsize my dbc to SQLSERVER. But, I have a view that is based on another view to make the query. It worked great on local views but I can't upsize it to SQL SERVER.
>>Does that mean I can't do this in SQL SERVER?