"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?