sql server查询在线用户 

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

 

posted @ 2016-01-04 11:28  astrue  阅读(993)  评论(0)  编辑  收藏  举报