When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
In SQL server, you can tell server-instance-B about server-instance-A (ie. separate processes on the same server), and specify a way to map logins. This is useful when you're 'side-integrating' with a ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback