Hi!
I'd like to have some explanation about distributed transaction and how
to recover them.

I can start a distributed transaction using BEGIN DISTRIBUTED
TRANSACTION sql statement.
If a transaction is incomplete, thus not committed or rollback due to a
crash of sql server or my program (that is accessing to sql server), I
read that the transaction in into transaction log, active transaction
log.
Is this right? How can I take only active transaction log?

How can I recover the incompleted transaction? I read that Sql server
if restarted recover them automatically, or I can use RESTORE LOG sql
statement.
Is this true?

Then, if I need to recover incompleted transaction, is there a way to
know which are the incompleted transaction I'm going to recover?

Thank you!

datetime between problem
SQL Join question - getting most recent value in a history table
Select problem Msg. 156
NEED HElP with Properly applying DISTINCT function to Count Aggregate.
Clustered index scans