How can I know what query is executing by by a particural
user? (using sp id or any othe way.)
- 2 Answers
- 4685 Views
- I also Faced
- E-Mail Answers
Answer Posted / prem
DBCC INputbuffer(spid)- Displays the last statement sent
from a client to an instance of Microsoft SQL Server 2005.
First 256 characters only will be displayed.
SQL statements can also be captured by running a profiler.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Find columns used in stored procedure?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is the difference between ‘having’ clause and a ‘where’ clause?
Does sql server use t sql?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is the openxml statement in sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Which are new data types introduced in sql server 2008?
Is BCNF better than 2NF & 3NF? Why?
Is sql server a database?
Does server sql treat char as a variable-length or fixed-length column?
What is the contrast amongst drop and truncate?
How to execute a sql statement using odbc_exec()?
What are commonly used odbc functions in php?
