In case you have recurring deadlock issues then go thru the link mentioned below and you really dont knwo how to troubleshoot them:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Manu Jaidka