• 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)