Skip to end of metadata
Go to start of metadata

sqltext

Prints some of the SQL text the given spid has recently received

syntax:

dbcc sqltext (spid)

This command prints the contents of a buffer containing SQL language text recently received by the client.  The output may not contain a complete statement and isn't necessarily exactly what is currently being processed.   In general, the MDA monitoring tables monProcessSQLText and monSysSQLText are a more robust source for this information.

  • No labels