Posted on Leave a comment

Remote table-valued function calls are not allowed

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).

http://connect.microsoft.com/SQLServer/feedback/details/126162/remote-table-valued-function-calls-are-not-allowed