Error message:
Remote table-valued function calls are not allowed
The reason:
When selects from remote tables (linked servers) - the table must be called with an alias.
--error:
SELECT ... FROM LinkedServer.DBNAME.dbo.Tablename
-- ok:
SELECT ... FROM LinkedServer.DBNAME.dbo.Tablename t
Explanation:
I don't know, and I also don't know if anyone knows.