Groups | Blog | Home
all groups > sql server (microsoft) > april 2007 >

sql server (microsoft) : Stored Proces


Mike J
4/20/2007 3:38:39 PM
i need to pull data (Rows) from one server1 on machine1
to Server2 on machine2 (where stored proc is running)
Process the record set then update server1 of results

any examples here how to accomplish this task

[quoted text, click to view]

Jack Vamvas
4/22/2007 12:00:00 AM
Check Linked Servers. Essentially, reference the data from server 1 from the
alias created in the Linked Server. And then everything else is the same as
normal

--

Jack Vamvas
___________________________________
Need an IT job? <a href="http://www.itjobfeed.com">uk it jobs</a>



[quoted text, click to view]

Mike J
4/23/2007 4:13:40 PM
Thanks Jack

[quoted text, click to view]

AddThis Social Bookmark Button