sql2008表锁查询

SELECT
DB_NAME(resource_database_id),
OBJECT_NAME(resource_associated_entity_id, resource_database_id)
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT'

 select last_batch,spid=cast(spid as varchar(20)),
 (SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS query_text
 ,(SELECT text FROM sys.dm_exec_sql_text(context_info)) AS query_text1
 ,* from master..sysprocesses where dbid=db_id('heecerp')
 order by master..sysprocesses.last_batch desc