EXECUTE @RC = MYSRV.Mydb.dbo.zz_Mysp @LocationTVP, @RecordsInserted OUTPUT

If I am not mistaken this will show a number bigger than zero if I have in my linked sp
the output as @@rowcount

But what it will display if I have it like this: EXECUTE @RC = MYSRV.Mydb.dbo.zz_Mysp @LocationTVP
Non output. This will return what in a Linked server if
a)We do an update but there is not data on the where
b)We have data on insert