to have the remote data synchronised with local data anytime, what about using trigger in remote server's table to update the local table , of course using linked server in...
Using Linked Server is always gonna slow down the process when data grow...i prefer to have a DTS written that transfers data to a table in the local server either...