updates in Linked server

• mjschwenger

  SSCarpal Tunnel

  Points: 4019

  More actions

  June 18, 2004 at 1:13 pm

  #83243

  I have a linked server to Oracle 9i (both win2k, SQL server 2000 standard). When I execute statement to update the data in the linked ORA server - everything is OK, but I need to make the opposite update as well - When the data in the liked server is updated I need to update the SQL Server data. How could I accomplish that?

  Any ideas are appreciated.

  Thanks,

  MJ

   

   

• June 21, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Ajay Sura

  Newbie

  Points: 6

  More actions

  March 22, 2005 at 12:14 pm

  #548290

  Try doing 2 separate updates. One on the Oracle and one on the SQL. Maybe I am just assuming that this is a straightforward problem...