高手请进--Cannot specify an index or locking hint for a remote data source
在SQL Server 2000 上,执行
SELECT ORD,OENO,ITEM
FROM PR1SQL.PR1_SFC.dbo.ORDHOLD WITH (NOLOCK)
WHERE WHSE in (select distinct WHSE from PR1SQL.PR1_COMM.dbo.WHSE where DIVISION = 'B1') order by ORD
Error message:
Server: Msg 7377, Level 16, State 1, Line 2
Cannot specify an index or locking hint for a remote data source.
去掉语句中的 WITH (NOLOCK) ,执行正常。
或去掉语句中的 PR1SQL ,执行正常.
请问怎么解决?