For example, when another transaction holds a lock, this message displays:
Cannot open the requested object for write in the current transaction (TxnID1). Another user has write access in transaction TxnID2.
Find TxnID2 in the output of sp_iqtransaction, and look for the name of the user in the same row of output.