Post reply

Distributed Transaction - OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.

  • November 8, 2004 at 8:54 am

    #165313

    First of all both sql servers are Windows 2000 and Sql 2000 sp3a.  I am trying to run insert into

     exec sp using a linked server and I am getting  OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.  I can do an insert into

    select, but that is muuch slower than running it via sp. I am successfully doing this to another SQL server (7.0) and remember having the same issue, but I cannot remember how I solved it.  Yes MSDTC is running on both machines. 

    Any ideas will be much appreciated

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • November 11, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 11, 2004 at 8:57 am

    #529794

    I've no idea on your error but I always do an insert using a sp as a rpc call - not sure if this is your answer?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 11, 2004 at 12:16 pm

    #529818

    set xact_abort ON

    have you tried setting it before you do your insert?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply