Locks4

Posted by: cadarsh89 on Aug 04, 2010 Print PDF

Tagged in: Untagged 

--Locks, Dead Locks: Checking the blocked DBs
select * from sys.sysprocesses where blocked>1  --query for checking the blocked state
select db_name(17)
select db_name(18)
sp_who2 63
dbcc inputbuffer (63)
kill 60
 


[ Back ]