I dunno what 'Linking server' is but you can create a linked server with type SQL Server and call stored procedure on it.

EXEC LinkedServerName.DBname.dbo.SPname ...

>
>Have you ever tried calling a stored procedure with the other Server?
>
>Like for example:
>
>Jeffreyeold1(instance name) has a database name “mts” and that database contains sp which is the “prc_insert_Sale”. And then another comes NEWJAN(instance name) which want to call the sp in the Jeffreyeold1.
>
>I already tried the code like this: jeffreyeold1.mts.dbo.prc_insert_Sale ………..
>
>It says that “jeffreyeold1” doesn’t found in the sysserver. So I added with use of sp_addlinkserver and then when I run it again it gave me an error and it says you have to use “RPC”. I don’t want to proceed maybe I’m lost. Please advice.