I have try to use linking server to link the remote server to get access for the table .
I use openquery command to get the data from the linked server . it is work fine.
but I use the openquery to create view I find that it prompt error.

so is it prossible to make a view with one local table with the remote sql server table ?
is there any other solution to solve this problem ?