I have blogged about the wonderful use of the SQL Profiler in SQL Server before.  The guys over at SQLServerCentral.com have another article with some awesome tips on using the Profiler to determine where deadlocks occur and in one particular case how to solve them.  Fantastic read if you do a lot of work with SQL Server.