I'm getting frequent deadlocks on SqlServer 2008. Currently, I have the following code in my data access layer to deal with it. It basically catches the deadlock and tries to resubmit the command with a new connection. No transactions. But it doesn't seem to work - users still get exceptions and my log shows that most of those exceptions were deadlocks. Can anyone tell what am I doing wrong? Thanks.I'm getting frequent deadlocks on SqlServer 200