Assuming that [11.99.120.12] is a linked server created on a SQL Server 2005 computer and pointing to a SQL Server 2000 computer, executing a simple query like this:
SELECT *
FROM [11.99.120.12].SALES_DB.dbo.ORDERS (nolock)
will fail with the following error message:
Server: Msg 4122, Level 16, State 1, Line 1
Remote table-valued function calls are not allowed.
This error message is not correct, since ORDERS is a table and not a function.
This query will run correctly only if the WITH keyword is used before the (nolock) hint:
SELECT *
FROM [11.99.120.12].SALES_DB.dbo.ORDERS WITH (nolock)
This problem is also discussed here.
Awesome - that was my problem, many thanks!
ReplyDelete