insert into diskplass execute sdsql04.master.dbo.xp_fixeddrives

Posted on 2005-05-13
Last Modified: 2009-07-29
"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?
Question by:olebrum030800
    LVL 7

    Expert Comment

    by:Jonathan Kelly
    is DTC running ?

    Author Comment

    Yes,  DTC is running.
    LVL 7

    Accepted Solution

    I have same error here when running similar code.

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

    but not
    LVL 7

    Expert Comment

    by:Jonathan Kelly
    did you get it to work ?

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now