try this link:

http://dbaspot.com/forums/sqlserver-server/367543-orphaned-transaction-sql-2005-a.html

Thank you ALZDBA, Jeff .

ALZDBA,

I am getting an error on @x.nodes('/i') x(i) . can you please check.

Jeff,

Thanks for the article. its too good.

But my problem still exists