sql server查询在线用户

select 
request_session_id spid,
object_name(resource_associated_entity_id) tableName
from sys.dm_tran_locks 
where resource_type='OBJECT'