Thanks Tony,

But in the hidden tool article its stated that It almost impossible to go through the complete Transaction Log file rather you have to create a log for the...

But this issue came just once the settings haven't been changed. So if the settings were the problem them the issue should be recreate able.

I am facing a similar problem

"The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed"

using a Project with VB6 and ADO without any linked servers. Can you elaborate...