var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do I see the full sql/query text of a spid?
How do I see the full sql/query text of a spid? I've been using the following dbcc commands to see the sql text.
The problem is it truncates the end, so I cannot see the entire query/sql text. Is there another way to a query/sql text that is being run?
Use MDA/Monitoring tables
order by SPID,BatchID,LineNumber,SequenceInLine
Also check and increase if necessary
sp_configure 'max SQL text monitored'
Great feedback and idea...
Thank you for your feedback...
I will use these great ideas. Thank you.