For all databases query sys.sysprocesses to find open transactions. It is useful to find locks in DB:
SELECT * FROM sys.sysprocesses WHERE open_tran = 1
For the current database use:
DBCC OPENTRAN
To find row counts for all tables. Very useful when we don’t know where to start when working in a new DB.
https://learn.microsoft.com/en-us/answers/questions/1073600/get-row-counts-for-all-tables-in-all-databases-in