Post reply

Insert multiple lines in a single row

  • January 18, 2013 at 9:50 pm

    #1578930

    Yes, it is a production server.

    Actually I connect to database server through an application. The application is running in several computers. I enabled MSDTC in the all client computers.

    To execute that trigger, I configured LinkedServer with the destination server. So I enabled MSDTC in both of the servers. Sometimes it works fine, sometimes it generates the error message.

    Error: The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Server2" was unable to begin a distributed transaction.

    I am not getting the clue why is it working like that.

    Please suggest me if there is any alternative of doing this.

  • January 18, 2013 at 10:06 pm

    #1578932

    The main concern is that I have to send some data in destination server so that mobile operator can convey SMS.

    Is there any alternative to do it beyond my activities?

  • January 19, 2013 at 11:22 am

    #1578976

    Details, how is MSDTC configured on both systems. It has been 5 to 7 years since I had to deal with this issue so I don't have complete memory on how I fixed it at a previous employer. Screen shots of each page of the MSDTC configuration would help. I'd put them in a Word doc and upload that.

  • January 19, 2013 at 9:20 pm

    #1579007

    MS DTC Config Screenshot

    If image not visible, pls Click Here

Viewing 4 posts - 16 through 18 (of 18 total)

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