I have a customer where the system was started with T1204 flag to check dead lock issue and I find almost constantly over the day dead locks are noticed. When I looked at the SPID in server logs that shows only cursorfetch and cursorclose statements. How can I get the actual SQL statement that caused deadlocks. I could get tablename and other line# but not the real SQLstatement.
In the same note how can I eliminate these deadlocks in a practical manner? Any help is very much appreciated.