CODEWITHSUNDEEP
sqlsql-serverdatabasestored-proceduressql-server-2012
Scooby
Scooby

Reputation: 3581

using stored procedure to connect to db in external server

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 ?

Upvotes: 0

Views: 1289

Answers (1)

T McKeown
T McKeown

Reputation: 12847

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..

Upvotes: 1

Related Questions