摘要:
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 阅读全文