SQL Profiler 2008 Deadlock Graph ToolTip Not Showing SQL
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. Do you know why? Is there a workaround?
When it says "statement proc" it refers to a stored procedure. You should see also a "database id" and "object id" (for example, 1460916255). You can find the name of the stored procedure by running SELECT OBJECT_NAME(1460916255). Huge efforts to develop such a strong ad complex component, and you need tu run a query more to reach the name of a stored procedure... absurd.
Is the data (sorry, query) there if you look in the .XDL file itself? Just open it up in Notepad or a proper text editor and have a look...
