The sp_iqlocks procedure displays information about locks currently held in the database.
The connection and user ID that holds the lock
The table on which the lock is held
The type of lock, and a name to identify the lock
The sp_iqtransaction procedure provides more detailed information about transactions. See Reference: Building Blocks, Tables, and Procedures