Example

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.