Ways to query data between two servers

Yes, set up Linked server for pointing to other server please. Read

http://technet.microsoft.com/en-us/library/ms188279.aspx

http://technet.microsoft.com/en-us/library/ff772782.aspx

---

Many Thanks & Best Regards, Hua Min