查看数据库被锁进程

select   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id)table_news   from   sys.dm_tran_locks

  where     resource_type   =   'OBJECT '