0
kicks
SQL Server 2005: Get full information about transaction locks
Get information about what locks are being held by the transaction, what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc...