Deadlock in SQL server

Question

Hi I want to know about deadlock in SQL server. How the deadlock occur in SQL server and how it can be resolved? Thanks

Vilas Gite · Answer

Hi Paul.. REFER THIS GOOD ARTICLE : http://www.c-sharpcorner.com/UploadFile/37db1d/7126/ MICROSOFT SUPPORT : http://support.microsoft.com/kb/826754 http://support.microsoft.com/kb/832524 Thanks! ---------------------------------------------------------------------- If this reply helps your post…then check  This is correct answer

Prabhu Raja · Answer

Hi smith A deadlock is a situation wherein two transactions wait for each other to give up their respective locks. Read this Article . Click Here -------------------------------------------- If this helps you then mark as Correct Answer