Displaying Active Locks

An attempt to write to a table fails if another transaction holds a lock on that table.

1. Run the sp_iqtransaction procedure.
2. Find the transaction identifier in the output of sp_iqtransaction.
3. Look for the name of the user in the same row of output.

• Example
  For example, when another transaction holds a lock, this message displays:
• Information about Locks in sp_iqlocks
  The sp_iqlocks procedure displays information about locks currently held in the database.