sql - using stored procedure to connect to db in external server -


i have stored procedure updates table taking data source , want modify stored procedure takes data table in external database , updates table in original server. can achieved , how ?

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

actually synonyms treated linked servers..


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -