Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem in executing distributed query Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 2:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Dear Sir,
I have configured a linked server using SSMS between two sql servers 2008 R2. Now I wrote a trigger on Server1 to insert row into Server2. I also enabled DTC and started it. When I execute the insert command, I get the following error.

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

Please help me to sort out the problem.

Regards,
Akbar
Post #1407690
Posted Wednesday, January 16, 2013 3:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:36 AM
Points: 2,840, Visits: 3,970
Dont cross post , it waste the time of people

the original thread is http://www.sqlservercentral.com/Forums/Topic1406594-391-1.aspx#bm1407719


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1407726
Posted Wednesday, January 16, 2013 10:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Sorry for that. I am going to delete the post.
Post #1408141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse