摘要: select request_session_id as id,OBJECT_NAME(resource_associated_entity_id) as tablename from sys.dm_tran_lockswhere resource_type=’OBJECT’kill id 例如:kill 58------------------------鎖測試:begin transelect * from brand with (TABLOCKX)raiserror ('dd',16,1)commit tran------------------------raiserr 阅读全文
posted @ 2012-08-15 10:49 Yaoquan.Luo 阅读(342) 评论(0) 推荐(0) 编辑