How can I know what query is executing by by a particural
user? (using sp id or any othe way.)
- 2 Answers
- 4686 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the need for group functions in sql?
What is difference between clustered and non clustered index?
What is the difference between varchar and nvarchar?
Define Business Edition in SQL Azure?
How you can find out if an index is useful to the optimizer?
Distinguish between commit and rollback?
Where is localdb stored?
What are the advantages of log shipping?
What is Dependency Injection and provide example?
Where are SQL server users names and passwords are stored in sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is analysis service repository?
What are the default system databases in sql server 2000?
What are different types of statements that are supported by sql?
How can I know what locks are running on which resource?
