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
Post a Comment