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
- 5344 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 the advantages to use stored procedures?
How to maintain a fill factor in existing indexes?
What are basics of policy management?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How to choose all records from the table?
Can you create a logon trigger in sql server 2005 express edition?
Explain indexed views and partitioned view with their syntax.
What is Federation Root Database?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can you name a few encryption mechanisms in sql server?
How to create a large table with random data for index testing in ms sql server?
Can we perform backup restore operation on tempdb?
Mention the 3 ways to get a count of the number of records in a table.
Are all views updatable ?
