SQL2005 distributed transactions

• FelixG

  SSCrazy

  Points: 2550

  More actions

  January 15, 2009 at 11:53 am

  #126760

  Hello everybody:

  I'm trying to insert the result set of one stored procedure that runs in a linked server into a temp table and receive this error message:

  OLE DB provider "SQLNCLI" for linked server "172.30.1.3" returned message "The transaction manager has disabled its support for remote/network transactions.".

  Msg 7391, Level 16, State 2, Procedure spu_estadistic_swift_from_SEOI, Line 10

  The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "172.30.1.3" was unable to begin a distributed transaction.

  The code of the actual procedure es trivial:

  create table #t

  (group tinyint, subgroup tinyint, order tinyint, concep varchar(40), quantity int);

  insert #t exec [172.30.1.3].operations.dbo.spu_estadistic_swift_from_seoi @date1

  What can I do to avoid this problem???

  Thanks in advance,

  Felix

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 15, 2009 at 11:54 am

  #927596

  You'll have to enable distributed transactions (and possibly RPC) on the remote server. Books Online has instructions on both of those things.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon