How to automatically re-run deadlocked transaction? (ASP.NET MVC/MS SQL)
- by Alex
I have a very popular site in ASP.NET MVC/MS SQL, and unfortunately a lot of deadlocks occur. While I'm trying to figure out why they occur via the SQL profiler, I wonder how I can change the default behavior of MS SQL Server when doing the deadlocks.
Is it possible to re-run the transaction(s) that caused problems instead of showing the error screen?