摘要:
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
阅读(355)
评论(0)
推荐(0)
浙公网安备 33010602011771号