SELECT DEST.TEXT
FROM sys.[dm_exec_connections] SDEC
CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST
WHERE SDEC.[most_recent_session_id] = (SELECT @@SPID)
Friday, August 21, 2009
Identify last statement run for a specific SQL Server session
Subscribe to:
Posts (Atom)