Locking tools

sp_who, sp_lock, and sp_familylock report on locks held by users and show processes that are blocked by other transactions.