查看被锁表:
select
spId
from
master..SysProcesses
where
db_Name(dbID) =
'数据库名称'
and
spId <> @@SpId
and
dbID <> 0
解除锁:
exec
(
'Kill '
+
cast
(@spid
as
varchar
))
查看被锁表
select
request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type=
'OBJECT'
spid 锁表进程
tableName 被锁表名
解锁:
declare
@spid
int
Set
@spid = 57
--锁表进程
declare
@sql
varchar
(1000)
set
@sql=
'kill '
+
cast
(@spid
as
varchar
)
exec
(@sql)