Home Forums Article Discussions Article Discussions by Author Discuss content posted by Praveen Voleti A Deadlock Occurence and Resolution RE: A Deadlock Occurence and Resolution
harry9katz
SSC Enthusiast
Points: 110
More actions
February 6, 2009 at 6:51 am
#939454
Right U are but U can see all the blocked paid's by order of waittime and can see what spid A is Doing by DBCC inputbuffur(spid a)
and decide if to kill the process or not.
this is a fast solution not clean as in the article