Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --查被锁表
- select request_session_id 进程,OBJECT_NAME(resource_associated_entity_id) 表名
- from sys.dm_tran_locks where resource_type='OBJECT';
- --解锁
- declare @spid int
- Set @spid = 666 --锁表进程
- declare @sql varchar(1000)
- set @sql='kill '+cast(@spid as varchar)
- exec(@sql)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement