I prefer singular because i like to have the id named the same as the table. So I have a table "Person" the id is "idPerson". The id is representing...

I don't know any other way, and I didn't find any documentation related to this specific situation. I played a whole day the time I needed to do this thing....

Create NewUser1 in first server.

Create NewUser2 in remote server and grant select permissions.

Map NewUser1 to NewUser2 in linkedserver configuration.

In the first server create StoredProcCallLinkedServer

as select * from server.db.sch.table

Create also StoredProcExecuteAS

AS

EXECUTE...