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
- 5249 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 status of services on passive node for failover cluster in sql server? : sql server database administration
Where views are stored in sql server?
How do I start sql server agent automatically?
What do you know about system database? : SQL Server Architecture
What is rolap and its advantage? : sql server analysis services, ssas
Explain datetime2 data type in sal server 2008?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
what is a schema in sql server 2005? : Sql server database administration
Explain what role entity and relationship play in an ER diagram.
Explain the difference between function and stored procedure?
What happens if null values are involved in arithmetic operations?
What is sql language?
