How do I determine if I'm having MSDTC problems between the NQCCDB and a QDB? (NETIQKB73227)

How do I determine if I'm having MSDTC problems between the Control center Database (NQCCDB) and an AppManager Repository Database (QDB)?

In SQL Management Studio, run the following query against the NQCCDB Database:

Begin distributed Tran
Select * from [hostname].[QDB].dbo.object
Commit Tran

Replace [hostname] with the name of the SQL Server hosting the repository in question, and replace [QDB] with the actual repository name (which is QDB by default).

If you get rows returned, you do not have an MSDTC problem.  If you get an error, you likely have an MSDTC issue, the error in the query results should provide more information to troubleshoot with.  NetIQ is not responsible for MSDTC issues, you should work with a Server Admin or Microsoft to resolve this issue.

Formerly known as NETIQKB73227