Prints some of the SQL text the given spid has recently received
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.