Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Question Unanswered: distributed transaction failure

    Im attempting to insert the result set from a remote query into a local table and Im getting the following error:

    Msg 8501, Level 16, State 1, Line 1
    MSDTC on server 'REMOTESVR' is unavailable.
    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d01c].
    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.


    MSDTC is running on both servers. Has anyone ever seen this or have any insight into the cause?


    The code that Im trying to run is:

    create table msver
    (
    [Index] int,
    [Name] varchar(30),
    Internal_Value varchar(20),
    Character_Value varchar(512)
    )

    insert into msver
    exec ('exec [REMOTESVR].master.dbo.xp_msver')


    Note that the remote query works fine.

    Thanks!
    Eric

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Make sure MSDTC is started on both the servers.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I might be wrong, but I don't think you're going to get xp_msver to work this way. Run it as:

    insert msver
    exec [REMOTESVR].sp_executesql 'exec master.dbo.xp_msver'

    See if that works. I don't have my laptop hooked up, or I would test it really quick at the lab.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check on the 'remoteserver' SQL server error log for #
    ".... server Attempting to initialize Distributed Transaction Coordinator..."
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •