SELECT * FROM Master.dbo.sysprocesses WHERE DBID NOT IN (1,2,3,4) -- Mas

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

Question Posted / suvendu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is pessimistic concurrency?

922

what is denormalization? : Sql server database administration

877

How to grant a permission in ms sql server using "grant execute" statements?

1025

What is a deadlock and what is a live lock?

951

What is an indexing technique?

869

How to call a function from a stored procedure in SQL Server ?

953

ow to bring suspect mode datbase online from scratch

1762

What is table value parameters (tvp)?

1037

What are the results of running this script?

861

What is subquery? Explain the properties of a subquery?

925

What happens to a trigger with multiple affected rows?

865

What is the difference between getdate and sysdatetime?

941

What are the different type of replication in sql server?

933

What are user-defined functions (udfs) in sql server?

935

Mention the differences between local and global temporary tables.

952