通过SPID得到此用户发出的查询语句
例如:得到当前用户的query:
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sys.sysprocesses WHERE spid = @@spid
SELECT * FROM ::fn_get_sql(@Handle)
go
皓首穷经,十年磨一剑
例如:得到当前用户的query:
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sys.sysprocesses WHERE spid = @@spid
SELECT * FROM ::fn_get_sql(@Handle)
go