In a deadlock graph, hovering over the deadlock ovals should produce the SQL statement. However, in SQL Profiler 2008, the ToolTip is either showing "Statement" or "Statement Proc" and not the statement itself. Does anyone ? Is there a workaround?
Not sure why these wouldn't show up in the graphic itself. Perhaps worth reporting as a bug on Microsoft Connect.
As a workaround you could try using the "Extract Event Data" option to save as XML and look for them there.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With