• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

insert into diskplass execute sdsql04.master.dbo.xp_fixeddrives

"insert into diskplass execute sdsql04.master.dbo.xp_fixeddrives"
This query returns an error message:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
The transaction active in this session has been committed or aborted by another session.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Running on sql-server 2000 on both current sql server and the remote server sdsql04.

running "execute sdsql04.master.dbo.xp_fixeddrives" separatelly gives a result set.
but this code returns the error message:
create table #diskspace
(Drive char(2), MB_Free int)
insert into diskspace execute sdsql04.master.dbo.xp_fixeddrives

Could someone help me?
0
olebrum030800
Asked:
olebrum030800
  • 3
1 Solution
 
Jonathan KellyCommented:
is DTC running ?
0
 
olebrum030800Author Commented:
Yes,  DTC is running.
0
 
Jonathan KellyCommented:
I have same error here when running similar code.

http://www.sqlnewsgroups.net/link.aspx?url=http://support.microsoft.com/kb/329332
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1237.aspx

i can run simple insert
insert into server1.TEST.dbo.TABLE1 select * from server2.test.dbo.table1

but not
dbo.xp_fixeddrives
0
 
Jonathan KellyCommented:
did you get it to work ?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now