查看sqlserver被锁的表以及如何解锁.
摘要:
查看被锁表:select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableNamefrom sys.dm_tran_locks whereresource_type='OBJECT'spid 锁表进程ta... 阅读全文
posted @ 2015-02-12 09:39 Davidhuang 阅读(146) 评论(0) 推荐(0) 编辑