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)
Subscribe to:
Post Comments (Atom)
By:Chandrakant Hibare- Software Engineer,Working with Spain Based Company,Bangalore
No comments:
Post a Comment