select request_session_id spid, object_name(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type=‘OBJECT‘
sql server查询在线用户
原文：http://www.cnblogs.com/mtsl/p/5098252.html
