How to make the Inner Remote Join work?

I am attempting to make an update on a remote server table with a join on a
local server table. The SQL looks like this:
update [Remote-Server].RemoteDB.dbo.RemoteTable
set Col1=LT.Col1
from LocalTable LT inner remote join
[Remote-Server].RemoteDB.dbo.RemoteTable RT
on LT.istringId=RT.istringId
But I got a returned error msg saying:
Server: Msg 7376, Level 16, State 1, Line 1
Could not enforce the remote join hint for this query.
What should I do to make the remote join work?hi Kingsia
just see if this help you:
http://www.windowsitpro.com/Article...2084/22084.html
regards,
Chandra
"kingsia" wrote:

> I am attempting to make an update on a remote server table with a join on
a
> local server table. The SQL looks like this:
> update [Remote-Server].RemoteDB.dbo.RemoteTable
> set Col1=LT.Col1
> from LocalTable LT inner remote join
> [Remote-Server].RemoteDB.dbo.RemoteTable RT
> on LT.istringId=RT.istringId
> But I got a returned error msg saying:
> Server: Msg 7376, Level 16, State 1, Line 1
> Could not enforce the remote join hint for this query.
> What should I do to make the remote join work?|||I've had the same problem on a DELETE. If you have SQL Server 7.0, article 3
09182 "Slow
DELETE or UPDATE Against Non-SQL Linked Server" (Microsoft Knowledge Base) s
eems to be saying it just doesn't work.
We have 7.0 so I'm giving up on the remote join and I'm going to copy my dat
a to a staging area(table) and then pull it over
from the other machine. It's frustrating. If you have any answers let me k
now at
smott@.twinlanes.com
> I am attempting to make an update on a remote server table with a join on
a
> local server table. The SQL looks like this:
> set Col1=LT.Col1
> from LocalTable LT inner remote join
> [Remote-Server].RemoteDB.dbo.RemoteTable RT
> on LT.istringId=RT.istringId
> Server: Msg 7376, Level 16, State 1, Line 1
> Could not enforce the remote join hint for this query.
User submitted from AEWNET (http://www.aewnet.com/)|||Hi Chandra,
I had seen that article before I posted this problem. It illustrated very
well how much better by using the Remote Join, but looked like the author
never encountered the same problem that I am facing.
Thanks anyway.
Kingsia
"Chandra" wrote:
> hi Kingsia
> just see if this help you:
> http://www.windowsitpro.com/Article...2084/22084.html
> regards,
> Chandra
>
> "kingsia" wrote:
>