January 16, 2013 at 2:19 am
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
January 16, 2013 at 3:35 am
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;-)
January 16, 2013 at 10:13 pm
Sorry for that. I am going to delete the post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply