[ftmjr]

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.

dbcc traceon(3604)
go

dbcc sqltext(559)
go

dbcc traceoff(3604)
go

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?

Thank you

[pdreyer]

Use MDA/Monitoring tables

select SQLText 
from master..monProcessSQLText 
where SPID=@parm
order by SPID,BatchID,LineNumber,SequenceInLine

[pdreyer]

Also check and increase if necessary
sp_configure 'max SQL text monitored'

[ftmjr]

Thank you for your feedback...

I will use these great ideas. Thank you.