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