Is there a way to take a peek what's encapsulated within a DTC transaction?
I've tried the SQL profiler (SQL 7.0),and it doesn't allow me to do so.
The reason that I am asking is that I have noticed for some unknown reasons that during high activity levels (in terms of transacations, which can be checked within the Component Services MMC snap-in in a Win2K server),some of the transactions get aborted after DTC transaction time-out period has been reached.I am trying to find out what are the SQL statements which is causing such behaviour.

Thanks in advance for any useful insights!