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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
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: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
Sorry for that. I am going to delete the post.
Post #1408141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse