摘要：
select t1.* ,t2.name from sys.dm_tran_locks t1 inner join sys.tables t2 on t1.resource_associated_entity_id = t2.object_id where resource_type = 'OBJECT' sys.dm_tran_locks:所有锁的信息 sys.tables:所有表的信息 ... 阅读全文
posted @ 2007-08-22 14:09 懒人ABC 阅读(520) 评论(0) 推荐(0) 编辑