asked on

Communication between servers

Hi,
I want to write a stored procedure that communicate with another sever. I need to insert some rows of table 'X' of Server 'S' to another table 'Y' of another server 'D'.

In which server my stored procedure must reside.

regards
Shaji

Guy Hengel [angelIII / a3]

The stored procedure must reside on the server from where you execute it. The rest can be solved with linked server, with give you the ability to "select" data from other server.
Cheers

ASKER CERTIFIED SOLUTION

nigelrivett

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jgould

Hello Shaji_am,

you've got several open questions

https://www.experts-exchange.com/questions/20117472/Arraya-in-SQL-server.html
https://www.experts-exchange.com/questions/20117484/Communication-between-servers.html
https://www.experts-exchange.com/questions/20247782/Database-Restore.html
https://www.experts-exchange.com/questions/20340207/display-values.html
https://www.experts-exchange.com/questions/20105806/Creating-a-new-port-in-a-Local-machine.html

you have 3 options

-accept a comment as answer
-if already solved it state the solution and get a refund of your points
-otherwise if you want to delete the question, make it clear in the thread

IMPORTANT : Experts if you got any recomendation on clsoing the question let it be known too

your last login is of 6 november 2002 so you're still active here

i will come back in 7 days and will close the question accordingly

thanks
JGould-EE Moderator