yes this will not stop deadlocks on its own there are a number of things you must do, look at the table and how they are set-up the code you can commit trans before starting a new one this will also help. there are many ways to reduce dead locks one of the ways is to use row level locking, however, as they will always be a part of life the best way is to identify the underling in application causes and make the appropriate changes to that.