SQL Query Fragments
tleblanc
Posts: 17 Bronze 2
I'm getting a deadlock and the SQL fragment that is displayed is truly that--a fragment. Is there any way to see the whole query?
Comments
SQL Monitor is able to capture the full query only when you are running trace. Trace can be enabled from the Configuration > Trace page. Please note that trace has a performance impact on your monitored server and should only be used for a short period of time when diagnosing a problem.