By the looks of the error you received you're attempting to get data from a table-valued function on the remote server, not a hard table, and thus the hint "WITH (NOLOCK)" doesn't even apply.