Running query in linked server through trigger

• gkeeara

  SSC Veteran

  Points: 228

  More actions

  August 1, 2006 at 11:38 pm

  #90350

  i have set up a linked server. i can query the linked server in query analyzer and also do update/delete. but when i try to run the same query for linked server through insert trigger, i get following error:

  [OLE/DB provider returned message. [Microsoft][ODBC Sql Server Driver]Distributed transaction error].

  btw, i am using Sql server 2000, SP4. main server is windows 2003 server and linked server is windows xp pro.

  any suggestions will be appreciated.

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  August 2, 2006 at 2:02 am

  #652749

  SET XACT_ABORT ON at the begging of trigger

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• gkeeara

  SSC Veteran

  Points: 228

  More actions

  August 2, 2006 at 5:18 pm

  #652961

  thanks dinesh.

  that did the trick.