Msg 7391 issue.....

[DLu]

Hi:

I want to capture the disk info, here are the simplified code:

create table #tblInfo
(driveName char(1) not null default '',
MBFree int not null default 0)

insert into #tblInfo (driveName, MBFree)
exec serverABC.master.dbo.xp_fixeddrives

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

Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "serverABC" was unable to begin a distributed transaction.

to run exec serverABC.master.dbo.xp_fixeddrives
returns the result, how could I capture it into a remote table?

thanks
David

[skhanal]

Is MSDTC running in your server?

[DLu]

Hi skhanal:

the remote serverABC is SQL2000 sp4 and MSDTC is on.

my pc is winXP SQL2005 sp2, and msdtc is on too.

it looks for any insert into mypcTable is ok for any remote select statement.

it looks for any insert into mypcTable is NOT ok for any remote exec statement.

I found an alternative is to put the proc at remote db and collect dat to a remote db table, then run select to insert to myPCTable. inconvienent ..... unless above msg 7391 is resolved.


thanks
David