Hi,

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.

Hoping for quick feedbacks and GOD BLESS

Kind Regards,
Jan