Deadlock Trace

• • Reply

  13 years ago

  by muneerpappattu

  Muneer Mohammed

  Riyadh, Saudi Arabia

  Joined 15 years ago

  Dear Friends,

  I am using SQL Server 2005 Database for Sales Accounting System.

  I am getting around 30 deadlocks everyday by 75 users.

  I know that I can trace the Deadlocks using the SQL Profiler. But how I can know (trace) the requested SQL Statement which leaded into Deadlock situation.

   

  Thanks in Advance for your help....

  Muneer

  Report abuse