Error: Remote table-valued function calls are not allowed
Fix: use “WITH (NOLOCK)” instead of just “(NOLOCK)
Explanation: When issuing a select that has uses four part naming to address the table and the table has a (nolock) hint, the t-sql will fail to execute with the error “Remote table-valued function calls are not allowed.”
If you execute the query with 3 or 2 part naming it runs without error.
To get the query to work using 4 part naming you have to put the “with” keyword before the (nolock).