Interested to Buy Any Domain ? << Click Here >> for more details...
How can I know what query is executing by by a particural
user? (using sp id or any othe way.)
- 2 Answers
- 5265 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 are database states in ms sql server?
What does Master database contains?
What is the distinction amongst delete and truncate?
How to select true false based on column value in sql server?
How do I view a stored procedure in sql server query?
Explain how you can deploy an SSRS report?
Why use “in” clause in sql server?
What is service broker? : sql server database administration
What are key constraints?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What happens if you delete a table that is used by a view?
explain declarative management framework (dmf) in sql server 2008?
What is the difference between coalesce() & isnull()?
What does it mean to invest in the index?
Do I need a report server to run reports in my application?
