Following command will give you detail of all the processes
sp_who2
You can find out all the process which have created blocking through following command
select cmd,* from sys.sysprocesses where blocked > 0
You can kill the blocking process with the following command
kill 54
sp_who2
You can find out all the process which have created blocking through following command
select cmd,* from sys.sysprocesses where blocked > 0
You can kill the blocking process with the following command
kill 54
No comments:
Post a Comment