SELECT
REQUEST_SESSION_ID SPID
, OBJECT_NAME (RESOURCE_ASSOCIATED_ENTITY_ID) TABLENAME
FROM SYS.DM_TRAN_LOCKS
WHERE RESOURCE_TYPE = 'OBJECT'
DECLARE @SPID INT
SET @SPID = 64 --锁表进程
DECLARE @SQL VARCHAR (1000)
SET @SQL = 'KILL ' + CAST(@SPID AS VARCHAR)
EXEC (@SQL)
Copyright © 2015 Powered by MWeb, Theme used GitHub CSS.