How do I fix a Query fails on linked server
Posted on 2012-03-16
I have 3 SQL Servers running: SERVER A, SERVER B, SERVER C
A table on SERVER A where trigger a INSERTS data on SERVER B and then calls Stored Proc (SP) on SERVER B.
The SP on SERVER B updates that same table with data retrieved from SERVER A and SERVER C. This is where it fails.
If I copied both tables to SERVER B the SP executes successfully... So I know the syntax is correct.
The problem occurs when and ONLY when I attempt to UPDATE the table on SERVER B with the join that links back to SERVER A. Any ideas.
In Visual studio or enterprise mgr. and do the single query to that table it passes the results.