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 database,that's gives me error.

Learn how to troubleshoot and resolve SQL Server deadlocks effectively with our comprehensive guide for database administrators.

Learn what a deadlock is, how to detect it, how to resolve it, and how to avoid it in SQL. Follow these best practices and techniques to prevent deadlocks and improve your database performance.

/* * Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204 */ -- Scope of a Trace Flag can be either set to Global or Session Only. However, 1204 & 1222 trace flags can be set Global Only. - ...

Bug description If a connection triggers a deadlock on SQL Server, the following queries in that connection throw an exception on a transaction descriptor. Additionally, if connection gets to a ...

You can track this through a Counter Log, import the performance data to the SQL Profiler and view a synchronized graph with your trace. In this way it is easy to spot the deadlocks.