Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to find the query running on a given SPID?

SQL Computer Science T SQL
user-image
Question added by antonios awadallah , HRMS Application Consultant , HITS Technologies
Date Posted: 2016/12/28
Upvote (0) Views (12) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Sarfaraz Alam
by Sarfaraz Alam , Software Developer , LC Biz

SELECT * FROM sys.dm_exec_requests er

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)

 WHERE session_id=@YourSesionID

Write Your Answer
More Questions Like This