Query locked obejct in SQL

1, use sp_lock to get all spid locked

2, select object_name(objid from 1), you can get object name locked.