Should be an easy linked server (delete command) question 1

[hoggle]

I have working linked server (ie I can pull data from it). The problem I'm running into is when I'm trying to execute a delete command, basically I want to delete any records on server2(SO_90), where the id is in another table on server1(tempE).

here's my (incorrect syntax)
DELETE FROM SERVER2.QueryTrx.dbo.SO_90
WHERE EXISTS(
SELECT * FROM tempE
WHERE SERVER2.QueryTrx.dbo.SO_90.SalesOrderNumber=tempE.SalesOrderNumber
)

the error I keep getting is:
Server: Msg 117, Level 15, State 2, Line 4
The number name 'SERVER2.QueryTrx.dbo.SO_90' contains more than the maximum number of prefixes. The maximum is 3.

I've been fighting all morning with this, thanks for any help

 

[JamesLean]

Try this (execute on Server1):

DELETE server2.querytrx.dbo.so_90
FROM server2.querytrx.dbo.so_90 t1 JOIN tempe t2 ON t1.salesordernumber = t2.salesordernumber

--James

 

[hoggle]

Thanks so much, works like a champ