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

Contribute to sqlserver-parikh/SQLServer development by creating an account on GitHub.

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.

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