reza141414

linked server is good suggestion but webservice is not because i use some join and sotoreprocedure in my database...

Linked Server is obviosly the best solution to get data from two different server's database.

If you are talking about the same, then go for linked server.