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 4, 2009 at 9:23 am
#938096
U can find the deadlock on line by running the script:
select * from master..sysprocesses where blocked>0 and spid<>blocked
order by waittime desc
and find the spid
then use :
dbcc inputbuffer (spid no)