I'm not a huge fan of linked servers. They cause me all kinds of performance and security issues. My suggestion would be to avoid that. IIRC, that will force calling stored procedures across linked servers. That's nearly always a better situation to be in.