Who is locking [2]
exec sp_lock exec sp_who 104 -- your spid exec sp_who2 104 -- your spid
Kill lock
KILL 104 -- your spid
Leave a Comment
exec sp_lock exec sp_who 104 -- your spid exec sp_who2 104 -- your spid
Kill lock
KILL 104 -- your spid