How can I know what query is executing by by a particural user? (using sp id

How can I know what query is executing by by a particural
user? (using sp id or any othe way.)

Question Posted / sridhar sahoo

2 Answers
4249 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can I know what query is executing by by a particural user? (using sp id or any othe way.)..

Answer / suvendu

SELECT *
FROM Master.dbo.sysprocesses
WHERE DBID NOT IN (1,2,3,4) -- Master, Tempdb, Model, MSDB
AND spid > 50
ORDER BY spid DESC

Is This Answer Correct ?

2 Yes

0 No

How can I know what query is executing by by a particural user? (using sp id or any othe way.)..

Answer / prem

DBCC INputbuffer(spid)- Displays the last statement sent
from a client to an instance of Microsoft SQL Server 2005.

First 256 characters only will be displayed.

SQL statements can also be captured by running a profiler.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer