using stored procedure to connect to db in external server

Question

I have a stored procedure that updates a table taking the data from a source and I want to modify the stored procedure so that it takes data from a table in an external database and updates a table in the original server. Can this be achieved and how ?

Check Linked Servers

Panagiotis Kanavos
– Panagiotis Kanavos

2014-03-10 15:02:17 +00:00
Commented Mar 10, 2014 at 15:02 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 10, 2014 at 15:02

T McKeown · Accepted Answer · 2014-03-10 15:10:52Z

1

See linked servers, it's treated just a synonym: http://msdn.microsoft.com/en-us/library/ff772782.aspx

Actually synonyms are treated like linked servers..

edited Mar 10, 2014 at 15:10

answered Mar 10, 2014 at 15:03

T McKeown

12.9k1 gold badge27 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using stored procedure to connect to db in external server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related