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 ...

Resolving locking issues with SQL Server 2008 R2 can be troublesome -- but it can also be surprisingly straightforward.

The SQL Profiler allows you to select the Deadlock Graph as a traced event. It captures deadlock information in XML format and displays it graphically in the tool.