Hi Guys, After migrating data from SQL Server 2000 to SQL Server 2008,when I am doing any a transaction in the table which find out more row on the ...

Deadlock automatically sorts players in the region it thinks best suits the user. For some players, this might be no problem, but others may find that they need to shake it up every so often.

If you want to play even if your local server is offline, you can do this by changing the region in Deadlock. This will let you keep on playing, although the connection might suffer.

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.