Search This Blog

Sunday 17 August 2014

dbcc sqltext(spid)

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.

1> dbcc sqltext(26)
2> go


SQL Text: select * from syscolumns