Display Users SQL Statement

[CliveW]

I know that this is a daft request, its just that I can't for the live of me remember how to view the last sql statement a user performed using t'sql.

Could anyone please put me out of my missery.

 

[TonyKhela]

You could go to Enterprise Mgr and goto current activity window, double click on the SPID.
Or you could look at the Log using a utility like 'Log Explorer'

http://www.kccltd.com.

hope it helps
TK

 

[SQLBill]

Look at DBCC INPUTBUFFER in the BOL.

Syntax:
DBCC INPUTBUFFER (spid)

-SQLBill

 

[CliveW]

thanks guys