I am using distributed transaction, in which I am inserting some date from
Server1.Db1 to Server1.db2, with same database schema.
and similar process in Server2 and server1,
i.e. inserting data From Server2.db3 to Server1.Db2
for the server1.Db1 to Server1.db2 the process is running ok.
but for server2.db3 to server1.db2, it was working earlier, but now when i call SqlCommand.ExecuteReader() at a specific point, the Connection property of the Transaction is being set to nothing, and the transaction rolls back.
it is something like that table has some kind of corruption, but i am able to fire all commands on that table locally.
but not from server2, then it causes problems.
when i drop and recreate that table, then again it starts working for server2 too.
I am not able to find the reason and so not able to find the solution.
please help any one has resolved such kind of issue.
Thank you in advance,